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

you must click the Calculate Now (F9) or the Calculate Sheet (Shift+F9) command button on the Formulas tab of the Ribbon.
Exercising Your Options 49
Figure 2-3:
The Formulas tab’s options enable
you to change how formulas
in the spreadsheet are recal- culated.
✦ Manual option button to switch to total manual recalculation, whereby formulas that need updating are recalculated only when you click the Calculate Now (F9) or the Calculate Sheet (Shift+F9) command button on the Formulas tab of the Ribbon.
✦ EnableIterativeCalculationcheckboxtoenableordisableiterativecal- culations for formulas that Excel finds that it cannot solve on the first try.
✦ Maximum Iterations text box to change the number of times (100 is the default) that Excel recalculates a seemingly insolvable formula when the Enable Iterative Calculation check box contains a check mark by enter- ing a number between 1 and 32767 in the text box or by clicking the spin- ner buttons.
✦ Maximum Change text box to change the amount by which Excel incre- ments the guess value it applies each time the program recalculates the formula in an attempt to solve it by entering the new increment value in the text box.
Book I Chapter 2
Customizing Excel 2013