Cell referenced elsewhere

  • Thread starter Thread starter Dave Eade
  • Start date Start date
D

Dave Eade

Hi,
I have a workbook with a number of worksheets which I have inherited, one of
the worksheets has about 100 entries of what on the face of appears to be
just text.

Is there anyway to find out if any of the other worksheets use the data in
their formulas ie lookups etc?

I suppose I could try and delete the worksheet in revison mode and see what
happens, but I wondered if there was an easier way?

Thanks
 
Select your cell. Then you can use "Trace Dependents" under Formula
Auditing. This can be found on the TOOLS menu in Excel 2003 or on the
FORMULAS Tab in Excel 2007.

HTH
Elkar
 
You must log in or register to reply here.

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

How do I copy the contents of a cell into a footer 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Referencing a cell 6
Replace worksheet without affecting the referencing formula 1
Summary worksheet referencing 100 worksheets 2
Creating A List of Items Between Two Numbers 2
Values from referenced cells 6
referencing a cell in another worksheet 5

Back
Top