Exceljet

Quick, clean, and to the point

Volatile function

Example of volatile function in Excel

A small number of Excel functions are "volatile". Volatile functions trigger recalculation on every worksheet change, so they can have a drastic impact on worksheet performance. In workbooks that contain a small amount of data, the performance impact may not be noticeable. But in workbooks with large data sets and lots of formulas, adding a volatile function can make the worksheet feel sluggish. In extreme cases, this can make a spreadsheet almost unusable.

Volatile function list

The following functions are considered volatile:

NOW()
TODAY()
RAND()
RANDBETWEEN()
OFFSET()
INDIRECT()
CELL() // depends on arguments
INFO() // depends on arguments
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables