View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Eade Dave Eade is offline
external usenet poster
 
Posts: 53
Default 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