Formula Evaluation Circumstances
|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|
Circumstances causing a formula to be evaluated.
A formula or part of a formula will be immediately evaluated whenever:
A formula in a conditional format will be evaluated at each recalculation or screen repaint of the cell containing the conditional format (conditional formats are volatile).
A formula will be flagged as uncalculated whenever it refers to (depends on) a cell, formula, name or value that has been
Certain actions will also unexpectedly flag a formula as uncalculated or trigger a recalculation: see volatile actions.
A formula that is flagged as uncalculated will be evaluated whenever the Range, Worksheet, Workbook or Excel instance that contains it is calculated or recalculated.
Note that a recalculation may also occur when opening a workbook in Automatic mode or when saving a workbook in Manual Mode with the Calculate before Save option. (See Controlling Calculation)
Circumstances causing a name to be evaluated.
The circumstances causing a name to be evaluated are not the same as a formula in a cell.