Tuesday, June 18, 2024
HomeMicrosoft OfficeMicrosoft ExcelExcel 2003: How To Disable Automatic Recalculation in a Worksheet

Excel 2003: How To Disable Automatic Recalculation in a Worksheet

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.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

LATEST REVIEWS

Recent Comments

error: Content is protected !!