Excel Calculation Methods
|Smart Recalculation||Evaluation Circumstances||Calculation Process||Dependency Trees|
|Controlling Calculation||"CALCULATE" in Status Bar||Calculation Methods||Calculating from VBA|
|Volatile Functions & Actions||User-Defined Functions||Repetitive Calculation||Version Timing Comparison|
For information on the calculation methods you can use from VBA see Calculating from VBA
Full Calculation and Re-Calculation.
Normally Excel calculates each cell as you enter it, and minimises
calculation by only recalculating all the dependents of all the changed
cells in all the open Workbooks.
Sheet Calculation, Range Calculation, Formula and Part Formula Calculation.
Excel has finer levels of calculation than just the workbook:
Recalculate Selected Worksheet(s) (Shift-F9)
Calculate Selected Range (using Range Calculate in VBA)
Calculating a Single Formula or Part Formula or Array Formula
Select the formula in the Formula Bar or highlight a part of the
formula in the Formula Bar and press F9.
Re-entering the = sign on the front of a block of formulae will make Excel recalculate them in a similar way to Range.calculate, except that the dependency tree for the formulae will also be rebuilt and in Excel2002 and 2003 the dependency recalculation of the range will not be done in Manual mode.
Step-by Step Formula Evaluation in Excel 2002/2003
Excel 2002 & 2003 has an Evaluate Formula button that allows you to watch as Excel steps through calculating a formula in the selected cell.