Excel: Turn Off Table Recalculation

Posted September 21, 2006 by Rob Rogers in Microsoft Excel

Excel recalculates the entire table if you make changes to any of the variables in a table formula. This can be problematic with large tables, which can take a long time to calculate. If you prefer to control the table recalculation, use the steps below.

Change to Manual Calculation Control:

1. Choose Tools.
2. Pick Options.
3. Select the Calculation tab, and then activate the Automatic Except Tables check box. This will cause Excel to not include data tables when it recalculates a worksheet.

To manually recalculate a table, press F9 (or Shift+F9 to recalculate the current worksheet only).


About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.