View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Warren Easton Warren Easton is offline
external usenet poster
 
Posts: 81
Default Tracing Dependents

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.