+ Reply to Thread
Results 1 to 4 of 4

Array Formulas Turn Out Regular Formulas When I Close and Reopen

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    922

    Array Formulas Turn Out Regular Formulas When I Close and Reopen

    There are some array formulas on a file. I open it then see the array formulas turned out regular formulas, then I fix them, close the file.

    Then open it and see they are regular formulas again. How to fix that?

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Array Formulas Turn Out Regular Formulas When I Close and Reopen

    Can you upload that problem file?
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    922

    Re: Array Formulas Turn Out Regular Formulas When I Close and Reopen

    The range E5:E15 contain array formulas however curly brackets will be gone when you fix those and save the file and open it again.
    Attached Files Attached Files

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Array Formulas Turn Out Regular Formulas When I Close and Reopen

    No problem here. Array formulae remain array formulae

    E9:E15 are not required to be array formulae.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Convert a group of formulas to array formulas at once
    By coach.32 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2015, 02:21 AM
  2. [Contribution] Use Excel regular formulas in VBA
    By joejiang2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2015, 02:48 AM
  3. Ctrl+Shift+Enter (CSE) array formulas in VBA using differing formulas
    By officeguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 04:31 PM
  4. Change all regular formulas into array formulas
    By sans in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-18-2012, 11:28 AM
  5. [SOLVED] Array formulas not working after close/re-open
    By PGOIBOY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2011, 11:57 AM
  6. Replies: 3
    Last Post: 04-19-2006, 01:55 AM
  7. [SOLVED] VBA Code dosent run after close & reopen
    By Jagdip Singh Ajimal in forum Excel General
    Replies: 2
    Last Post: 04-25-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1