+ Reply to Thread
Results 1 to 3 of 3

Disabling array formulas until needed?

  1. #1
    Forum Contributor
    Join Date
    10-14-2007
    MS-Off Ver
    Excel 2021
    Posts
    121

    Disabling array formulas until needed?

    I have a spreadsheet that has two worksheets:
    Worksheet 1 has absolutely no formulas associated to it and is all data entry.
    Worksheet 2 is a summary spreadsheet that has alot of complex array formulas that pulls a bunch of data from Worksheet 1.

    The problem i'm facing is that now when entering data in Worksheet 1 it takes nearly a second to recalculate all the formulas that are stored on Worksheet 2. Is there a way to disable the formulas from recalculating each time new data is entered in Worksheet 1 and only have the formulas run when i press a macro button?

    Hopefully there is an easy solution to this. Thank you
    Last edited by impala096; 10-07-2010 at 01:47 PM.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Disabling array formulas until needed?

    If you go to TOOLS-OPTIONS, you can set calculation to MANUAL. Then, whenever you need to calculate, simply press F9

  3. #3
    Forum Contributor
    Join Date
    10-14-2007
    MS-Off Ver
    Excel 2021
    Posts
    121

    Re: Disabling array formulas until needed?

    Thank you! I'm just adding 'Calculate' code within the macro now to automatically update it only when the macro runs. This makes life much easier .

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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