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

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