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

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android