Excel Trace Dependents tool

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

When using the Trace Dependents or Precedents from the Formula Auditing
toolbar if the reference is on another sheet Excel shows a little sheet
icon. Is there any way to find out which sheet it is referring to?

TIA


Peter
To err is human but it takes a computer to really mess things up
 
I've just noticed the post "Find Independent Workbooks" on 15/02/04 - I
guess this answers my question sort of. i.e there is no easy solution.

Peter
To err is human but it takes a computer to really mess things up
 
Peter said:
When using the Trace Dependents or Precedents from the Formula Auditing
toolbar if the reference is on another sheet Excel shows a little sheet
icon. Is there any way to find out which sheet it is referring to?
Click to expand...
[/QUOTE]
I've just noticed the post "Find Independent Workbooks" on 15/02/04 - I
guess this answers my question sort of. i.e there is no easy
Click to expand...
solution.

If you look at the formula it will tell you (or get you close). Are
you wanting to do a whole heap of them a t once ?

Bruce

-----------------------------------------------------------------------
It was so much easier to blame it on Them. It was bleakly depressing to
think that They were Us. If it was Them, then nothing was anyone´s fault.
If it was Us, what did that make Me ? After all, I´m one of Us. I must be.
I´ve certainly never thought of myself as one of Them. No-one ever thinks
of themselves as one of Them. We´re always one of Us. It´s Them that do
the bad things. <=> Terry Pratchett. Jingo.
 
Back
Top