Find/list/format all volatile cells
Any way for excel to identify all volatile cells (and maybe as a separate list, all cells that depend on volatile cells) that would revolutionise our ability to improve a workbook's efficiency.
Excel must know this list of cells. Why not share it with the user! Surely this could be done really easily. even as a separate csv file report or something...
but preferably as a button (similar to 'Show formulae - ctrl+' ) that temporarily removed other formatting and coloured cells by whether they were volatile (black cell with white font), or dependent on a volatile cell (dark grey cell with white font). Then using the 'trace dependents' tools, we'd be able to pin point the problems and stop them snowballing...
Gareth Hayter commented
I agree, that would be a very useful feature. The FormulaDesk add-in already has this feature. Click the 'Performance Viewer' button on the FormulaDesk menu to access the feature to find all volatile cells. https://www.formuladesk.com