Microsoft Office Tutorials and References
In Depth Information
INSIDE OUT Legacy recalc
When you open an Excel 2010 or 2013 workbook, Excel recalculates only formulas that
depend on cell values that have changed. However, because of changes in the way Excel
2010/2013 recalculates, when you open a workbook that was saved in an earlier Excel
file format, Excel recalculates all the formulas in the workbook each time you open it.
To avoid this, save the workbook in the Excel Workbook (.xlsx or .xlsm) file format.
There are various reasons why you might want to prevent Excel from recalculating each
time you enter data in a cell, but computer speed, which used to be one of the top reasons,
really isn’t much of an issue anymore (unless your computer is very old). Nevertheless, you
can switch from automatic to manual recalculation, and Excel will recalculate only when
you tell it to. To set manual recalculation, click the Calculation Options button on the
Formulas tab on the ribbon and then choose the Manual option. You can also click the File tab,
Options, and then select the Formulas category to display the additional options shown in
Here are a few facts to remember about calculation options:
With worksheet recalculation set to Manual, the status bar displays the word
Calculate if you make a change; click it to initiate recalculation immediately.
The Recalculate Workbook Before Saving check box helps make sure the most
current values are stored on disk.
To turn off automatic recalculation only for data tables, select the Automatic Except
For Data Tables option. For more information, see “Using data tables” in Chapter 18,
“Performing a what-if analysis.”
To recalculate all open workbooks, click the Calculate Now button in the Calculation
group on the Formulas tab, or press F9.
To calculate only the active worksheet in a workbook, click the Calculate Sheet button
in the Calculation group on the Formulas tab, or press Shift+F9.