Change when a spreadsheet calculates

MS OFfice Web Components Spreadsheet

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. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. On the spreadsheet toolbar, click Commands and Options , and then click the Workbook tab.
  3. 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.