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.
There is a
check mark for Enable iterative calculation. The default settings
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