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

Syncing between source worksheet and dependent worksheets 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Formula Auditing: Observing the Dependent Cells in Another Window 0
tracing precedent by double clicking cell 3
Q about trace dependent to worksheet icon 0
stumped on creating dependent data validation lists 1
trace dependent tool doesn't work but trace precendent doesn't 2
How to trace dependents across worksheets? 2

Top