Formula Auditing

J

Jeff

I want to use the "Trace Dependents" when the dependent cell is in another tab.

When this happens a little mini square icon appears. But there does not
appear to be any way of telling which tab or cells in the tab are dependent.

Is there anyway to get this info?

Thanks for your help
 
M

Max

Try double-clicking on the arrow which points to the mini square icon
The info will show in the "Go To" dialog which pops up.
 

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

How do I reference one OR another worksheet? 2
formula auditing problem 0
Formula Audit mode active in one column only; cannot kill. 2
Page numbering with Merged Document and IF statements 1
Formula Auditing 2
Trace Dependent - off worksheet page reference 1
Recover Outlook calendar entry 1
changing rows *and* columns in automatic formulae 1

Top