Trace dependents to graphs and names
When I clean up others' workbooks, I use Trace Dependents to make sure that I can safely delete a value without messing up any part of the file. However, Trace Dependents does not go to graphs or names, so I have to manually check those.
I feel that Trace Dependents should trace anything that depends on the cell being traced, not just cells.
Interesting idea. We’ll consider this in the next round of feature planning. In the meantime, please continue to vote on this idea.
Ron Kaminker commented
How about also being able to trace if a cell is used in conditional formatting or in a dropdown
this facility is essential - how tio vote??!
Ryan MacGregor commented
Or this tool, which can also trace dependent charts and names, specifically: https://www.macabacus.com/docs/excel/trace-precedents-dependents.
Jan Karel Pieterse commented
Like my tool is able to do: jkp-ads.com/reftreeanalyser.asp
I'd vote for thisone, but am out of votes :-(