Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List Dependent Worksheet Functions | Excel Discussion (Misc queries) | |||
Trace Dependent - off worksheet page reference | Excel Discussion (Misc queries) | |||
hyperlink will not follow when worksheet changes name | Excel Discussion (Misc queries) | |||
Q about trace dependent to worksheet icon | Excel Discussion (Misc queries) | |||
Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions |