Change when a spreadsheet calculates

When a spreadsheet contains many formulas, it might take a long time to calculate. To speed up your work, you can change the calculation mode from automatic to manual so that you can decide when to recalculate the spreadsheet.

1. On the spreadsheet toolbar, click Commands and Options , and then click the Workbook tab.
2. Under Calculation, do one of the following:

   • To recalculate the spreadsheet whenever a value changes, select Automatic.

   • To recalculate the spreadsheet only when you press F9 or click Calculate, select Manual.