This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Spreadsheet Modification Slow - Switch to Manual Calculation

Normally, Microsoft Excel 2003 automatically re-calculates formulas whenever you modify values referenced in the formulas. For example, if a formula sums the values of A5-A15 into cell A20, and you change the value of cell A9, A20's value would also change to reflect the new summation.

In extremely complex spreadsheets or on slower computers, automatic recalculation may take some time, slowing down data entry. If this occurs often, you may wish to switch Excel 2003 to manual calculation mode in that formulas are updated only when you tell Excel 2003 to recalculate them.

1. Click "Tools" - "Options".

2. When the "Options" multi-tabbed dialog box appears, click the "Calculation" tab.

3. Select the "Manual" radio button.

4. The checkbox "Recalculate before save" defaults to checked, meaning that before you save a spreadsheet, Excel 2003 will recalculate all values. If this causes spreadsheet saves to take too long, uncheck this box.

5. Click "OK" to close the dialog box.

Now, whenever you want to manually recalculate all formulas, just press the F9 key.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Spreadsheet Modification Slow - Switch to Manual Calculation.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.