Ten Minute Guide to Excel 97

Changing the Calculation Setting

Excel recalculates the formulas in a worksheet every time you edit a value in a cell. However, on a large worksheet, you may not want Excel to recalculate until you have entered all of your changes. For example, if you are entering a lot of changes to a worksheet that contains many formulas, you can speed up the response time by changing from automatic to manual recalculation. To change the recalculation setting, take the following steps:

1. Open the Toolsmenu and choose Options.

2. Click the Calculation tab to see the options shown in Figure 15.2.

   Figure 15.2. Change your calculation setting in the Options dialog box.

3. Select one of the following Calculation options:

   Automatic This is the default setting. It recalculates ...