How do I follow an arrow to a worksheet icon when tacing dependent
 

If I get a worksheet icon when tracing dependents, is there a way to
determine which worksheet or workbook dependes on the cell? Also the which
cell within that worksheet or workbook?

How do I follow an arrow to a worksheet icon when tacing dependent
 

Never mind, I found another post that reminded me that you just double click
the dotted line!

"goblue" wrote:

If I get a worksheet icon when tracing dependents, is there a way to
determine which worksheet or workbook dependes on the cell? Also the which
cell within that worksheet or workbook?

How do I follow an arrow to a worksheet icon when tacing dependent
 

Try double clicking on the dotted line
This surfaces the "Go To" dialog with the relevant info that you seek
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"goblue" wrote:
If I get a worksheet icon when tracing dependents, is there a way to
determine which worksheet or workbook dependes on the cell? Also the which
cell within that worksheet or workbook?