Friday, May 17, 2024
HomeMicrosoft OfficeMicrosoft ExcelExcel: Turn Off Table Recalculation

Excel: Turn Off Table Recalculation

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

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


Please enter your comment!
Please enter your name here

Most Popular


Recent Comments

error: Content is protected !!