Volatile function

Excel glossary definition

A function that recalculates on every worksheet change.

Definition

Functions such as NOW, TODAY, RAND, RANDBETWEEN, INDIRECT, and OFFSET recalculate whenever any cell changes, which can slow down large workbooks.

Back to Excel glossary