Volatile Excel Functions |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| A Volatile Function in a formula in a cell
makes that cell be always recalculated at each recalculation
even if it does not appear to have any changed precedents.
FastExcel measures Workbook Volatility by comparing the time for
a Recalculation to the time for a full calculation, and allows
you to measure worksheet volatility by comparing the sheet
recalculate time with the sheet full calculate time. Excel’s
Volatile Functions. Some of Excel’s functions are obviously
volatile: RAND(), NOW(), TODAY() Others are less obviously
volatile: OFFSET(), CELL(), INDIRECT(), INFO() Some are volatile
in some versions of Excel but not in others: INDEX()became non-
volatile in Excel 97. A number of functions that are