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.

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.


"dhstein" wrote:

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.

Try double-clicking the arrow.

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

"dhstein" wrote in message
...
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.