of them set to automatic calculation and the other set to manual calculation.
Although you can save a workbook with particular settings (for example, manual
calculation with no iterations), those settings can change if you open another
Excel follows these general rules to determine which calculation and iteration
settings to use:
The first workbook opened uses the calculation mode saved with that
workbook. If you open other workbooks, they use the same calculation
For example, suppose you have two workbooks: Book1 and Book2. Book1
has its Iteration setting turned off (the default setting), and Book2 (which
uses intentional circular references) has its Iteration setting turned on. If
you open Book1 and then Book2, both workbooks will have the iteration
setting turned off. If you open Book2 and then Book1, both workbooks
will have their iteration setting turned on.
Changing the calculation mode for one workbook changes the mode for
If you have both Book1 and Book2 open, changing the calculation mode
or Iteration setting of either workbook affects both workbooks.
All worksheets in a workbook use the same mode of calculation.
If you have all workbooks closed and you create a new workbook, the
new workbook uses the same calculation mode as the last closed work-
book. One exception: if you create the workbook from a template. If so,
the workbook uses the calculation mode specified in the template.
If the mode of calculation in a workbook changes, and you save the file,
the current mode of calculation saves with the workbook.
Circular Reference Examples
Following are a few more examples of using intentional circular references. They
demonstrate creating circular references for time stamping a cell, calculating
anall-time-high value, solving a recursive equation, and solving simultaneous
For these examples to work properly,you must have the Iteration setting in
effect.Select ToolsOptions,and click the Calculation tab.Make sure the
Iteration check box is checked.
Chapter 16: Intentional Circular References