Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Spreadsheet Modification Slow - Switch to Manual Calculation

Summary: Speed up slow Microsoft Excel 2003 spreadsheets by only calculating formulas manually, not in the background.

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.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: