Trace Dependents

  • Thread starter Thread starter George Tattam
  • Start date Start date
G

George Tattam

When using the auditing tool, trace dependents. If the arrow points to
another worksheet, is it possible to determine in which sheet of the
workbook the dependent cell exists?
 
If you double click on that line/arrow to the mini worksheet symbol, you'll see
a list of all the other ranges.
 
Thanks for your help Dave.

Dave Peterson said:
If you double click on that line/arrow to the mini worksheet symbol,
you'll see
a list of all the other ranges.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trace Precedents /dependents in another sheet 5
Data Validation drop down not showing and Formula Auditing bar greyedout 2
Fastest ways to trace formulas (especially when cells link to otherworksheets) 4
How do you ID cell precendents/dependents in other sheets? 2
Trace Dependents doesn't work (precedents does!) 4
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Call Macro if no Dependents 1
trace dependents 2

Back
Top