View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default trace all dependents

I'm working with a workbook that I didn't create. I want to delete some of
the sheets. Is there a way to determine if there are any references TO
(i.e., dependents) any cell on the sheet I want to delete from the workbook?

I stumbled on the trick to use a circular reference to trace all precedents
in a sheet which is useful but not in this scenario.

I'm using Excel 03 with XP.