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