Change when a spreadsheet calculates

Microsoft Office Web Components

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 Button image, 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.