A volatile function in Excel is a function that recalculates when a change occurs in a workbook, regardless of whether the input values ​​have actually changed. These operations are called volatile because they can significantly affect the performance and responsiveness of the workbook, especially when dealing with large amounts of data or complex formulas.
Here are a few examples of the volatile function:
NOW(), RAND(), TODAY(), OFFSET(), etc.