Tracing Dependents

[dhstein]

When I trace dependents, sometimes I get an arrow pointing to an icon of a
worksheet - I think it means there is a reference to that cell in another
sheet. How can I find that location? Thanks.

 

[Warren Easton]

Hi dhstein,

I usually double click on the dotted line not the Icon and Excel shows you a
table of all the dependants.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.

 

[Charles Williams]

Try double-clicking the arrow.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com