### Iterative Calculations

How many
times does Excel repeat a calculation? Once? Twice? Say you make a
mistake, a circular reference that adds itself to itself, then the
computer would calculate the same formula forever. You can set the
**iterative calculation** in the Backstage.

**
Try it: Set iterative Calculation Options**

Open any sample
spreadsheet you created in the previous lessons.

Go to**
File ->Options->Formulas.**

There is a
check mark for Enable iterative calculation. The default settings
are:

Maximum
Iterations: 100

Maximum
Change: 0.001

The
Maximum Change is the smallest change that you will accept between
calculations. The smaller the number, the more accurate the result
and the more time Excel needs to recalculate a worksheet