| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace Dependent - off worksheet page reference
when using the 'formula auditing' toolbar 'trace dependent' button and the
'other worksheet' icon comes up to indicate a cell/s on another worksheet are dependent upon the cell chosen, does anyone know how to find the dependent cells on the other worksheets?? Knowing there is a dependent cell on another sheet (without knowing where it is) is tormenting :( thanks in advance. Peter |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trace Dependent - off worksheet page reference
Double click on the precedent arrow, & follow the relevant Goto link.
-- David Biddulph "happy 111" wrote in message ... when using the 'formula auditing' toolbar 'trace dependent' button and the 'other worksheet' icon comes up to indicate a cell/s on another worksheet are dependent upon the cell chosen, does anyone know how to find the dependent cells on the other worksheets?? Knowing there is a dependent cell on another sheet (without knowing where it is) is tormenting :( thanks in advance. Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trace dependent tool doesn't work but trace precendent doesn't | Excel Discussion (Misc queries) | |||
| Q about trace dependent to worksheet icon | Excel Discussion (Misc queries) | |||
| Trace Dependent Cells of the Linked Files | Excel Discussion (Misc queries) | |||
| Data in cell to reference a worksheet page | Excel Worksheet Functions | |||
| Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
Linear Mode
