3 Ways to Stop Volatile Functions Recalculating in Microsoft Excel
Fix the values generated by volatile functions.
Volatile functions in Microsoft Excel are useful when you want to display real-time data, as they recalculate whenever a workbook is reopened, or when any other calculations are performed. However, you can fix the results they return, or temporarily prevent them from recalculating.
