Trace Precedents /dependents in another sheet

S

SammyH

Dear Experts

Im using Excel 2007
Im attempting to audit a sheet where the formula are in one sheet and the
totals are in another.
When using either the Trace Precedents or dependents function , all I get is
an arrow pointing to a worksheet icon without any info on the cell ref of
the formula or the dependent (depending on which way I run it) Is there any
way of getting this info if the data is on two separate sheets or files.

Thanks

Sam
 
M

Max

In xl2003, one could just double click on the dotted line which leads
to/from the little sheet icon. This would surface a "Go To" dialog revealing
the precedents/dependents. Maybe it works the same way in your xl2007?
 

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

Trace Dependents doesn't work (precedents does!) 4
Trace Precedents (Saving Tracing to print) 0
Trace Dependents 2
trace all dependents 1
Trace precedents from another worksheet 0
Trace dependents - can it auto-update / is there a keyboard shortc 0
Excel Trace Dependents tool 2
Unable to activate Trace Precedents or Dependents in Excel 2003 5

Top