Recalculation

The default behavior for Excel is to recalculate every function each time data in the spreadsheet changes. You might want to change the settings so that you must manually recalculate the spreadsheet by pressing the F9 (recalculate) key.

How to change this setting: in Excel 2003Select Tools > Options, and then change the Calculation settings on the Calculation tab., or Excel 2007Click the Office Button, select Excel Options, click on Formulas in the left-hand panel. Make any desired changes under Calculation Options section..

The Compeat Add-Ins menu contains several options for recalculating (these are also available by right-clicking a cell).

• Recalculate Sheet Recalculates all functions on the current sheet (and any functions that are dependent on them in other sheets). This marks cells in the current sheet as changed before calculating, so it will work in conditions where F9 would not recalculate.

• Recalculate All Recalculates all open workbooks; this is the equivalent of pressing CTRL-ALT-F9.

• Fast Recalculation Recalculates all open workbooks, with optimized performance. This method bundles many transactions together to be processed at once. This will significantly increase performance when running sheets against data portals that are not on the local network.