Trace Dependent - off worksheet page reference

[happy 111]

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

 

[David Biddulph]

Double click on the precedent arrow, & follow the relevant Goto link.