Calculation Preferences
Calculation preferences (Figure 7) control the way formulas are calculated (or recalculated) in a worksheet. There are several groups of options: Calculation, Iteration, Calc buttons, and Workbook options.
Figure 7. The default settings for the Calculation pane of the Preferences dialog.
Calculation
The Calculation area enables you to select one of three radio buttons for specifying how formulas should be calculated:
Automatic tells Excel to recalculate all dependent formulas whenever you change a value, formula, or name.
Automatic except tables is the same as Automatic, but does not recalculate data tables. With this option ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
