Page 354 - Excel 2013 All-in-One For Dummies

336 Circular References
Table 1-3
Option
Automatic
Automatic Except for Data Tables
Manual
Recalculate Workbook before Saving
Enable Iterative Calculation
Maximum Iterations
Maximum Change
Circular References
The Calculation Options in Excel 2013
Purpose
Calculates all dependent formulas and updates open or embed- ded charts every time you make a change to a value, formula, or name. This is the default setting for each new worksheet that you start.
Calculates all dependent formulas and updates open or embedded charts. Does not calculate data tables created with the Data Table feature. (See Book VII, Chapter 1, for informa- tion on creating data tables.) To recalculate data tables when this option button is selected, click the Calculate Now (F9) command button on the Formulas tab of the Ribbon or press F9 in the worksheet.
Calculates open worksheets and updates open or embedded charts only when you click the Calculate Now (F9) command button on the Formulas tab of the Ribbon or press F9 or Ctrl+= in the worksheet.
When this check box is selected, Excel calculates open work- sheets and updates open or embedded charts when you save them even when the Manually option button is selected.
When this check box is selected, Excel sets the iterations, that is, the number of times that a worksheet is recalculated, when performing goal seeking (see Book VII, Chapter 1) or resolving circular references to the number displayed in the Maximum Iterations text box.
Sets the maximum number of iterations (100 by default) when the Iteration check box is selected.
Sets the maximum amount of change to the values during each iteration (0.001 by default) when the Iteration check box is selected.
A circular reference in a formula is one that depends, directly or indirectly, on its own value. The most common type of circular reference occurs when you mistakenly refer in the formula to the cell in which you’re building the formula itself. For example, suppose that cell B10 is active when you build this formula:
=A10+B10