Excel 2003: How To Disable Automatic Recalculation in a Worksheet
Contributed by Rob Rogers 
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.
You may also like -
Excel: How To Bypass Table Recalculation
Excel 2007: Set the Default Column Width for a Worksheet
Excel 2007: How to View Twitter Updates (Tweets) in a Worksheet
Excel: Prevent Conversion of URLs into Hyperlinks
Excel 2007: Use Data Bars for Cell Value AnalysisMicrosoft Excel 2003: How To Disable Chart Tips
Excel: How To Reference Cells in Other Worksheets
Excel 2007: How to Sort Rows
Mr Web said on June 8, 2010
But there is no way to disable automatic calculation for just a specific file you are going to send someone. When he or she opens the file it will calculate (before Sub Workbook_Open) and stuck on it! You always have to remember to disable automatic recalculation by doing it the way describe above _before_ you open the file ;-(