Excel 2003: How To Disable Automatic Recalculation in a Worksheet

Contributed by shamanstears November 3, 2006  
Tagged: Microsoft Excel

By default, Excel automatically updates calculations when you alter data cells used in that calculation. If you have a very large worksheet, the updating can be slow. To disable automatic recalculation, follow this tech recipe:

1. Click Tools and select Options.

2. Select the Calculation tab.

3. Under Calculation, select the radio button next to Manual

4. Click OK.

To perform the calculation manually, simply press the F9 key.