Excel 2003: How To Disable Automatic Recalculation in a Worksheet

Posted November 3, 2006 by Rob Rogers in 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.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.