Excel: How To Bypass Table Recalculation

Contributed by shamanstears September 21, 2006  
Tagged: 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…

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).