tracing precedents and dependents

[Baja]

HI folks,

I'm using the auditing tool to trace precedents and
dependents to a cell.
Problem is if the precedent or dependents are on another
sheet, it won't tell me which sheets and which cells are
dependent to the cell I am examining.

Is there a way to find this out? any improvements to this
tool out there?

thanks

 

[Ken Wright]

Just doubleclick on the line linking the little spreadsheet box you can see

 

[Baja]

wow,
Thank you... learning something new everytime

 

[Ken Wright]

Stupid isn't it - You'd think you could click the damn spreadsheet icon