Trace Dependent - off worksheet page reference

H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tracing precedent by double clicking cell 3
How to trace dependents across worksheets? 2
stumped on creating dependent data validation lists 1
Finding Text within an Array 2
trace dependent tool doesn't work but trace precendent doesn't 2
tracing precedents and dependents 3
Trace Dependents 2
making a portion of reference to a worksheet variable in a formula 1

Top