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.
