Cell referenced elsewhere
 

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

Cell referenced elsewhere
 

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


"Dave Eade" wrote:

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