Does anyone know of any way to identify all volatile cells on a spreadsheet and/or in a workbook?
or, is there some way to see what cells will be re-calculated when another cell is changed?
Does anyone know of any way to identify all volatile cells on a spreadsheet and/or in a workbook?
or, is there some way to see what cells will be re-calculated when another cell is changed?
The group Formula Auditing on the Formulas ribbon contains commands to trace precedents and dependents of a cell. A precedent is a cell that is referenced by the current cell. A dependent is a cell that references (is dependent) on the current cell. When clicking these commands, arrows will appear that lead from the current cell to the precedents/dependents.
It does not differentiate between volatile and non-volatile formulas, though.
For more detailed analysis you may want to use the Excel Add-in called Inquire, or 3rd party tools.
If you want to find all volatile functions, you may want to search the workbook for formulas using RAND(), NOW(), TODAY(), OFFSET(), CELL(), INDIRECT(), and INFO().
For more details on volatile functions refer to http://www.decisionmodels.com/calcsecretsi.htm