View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Sheet Dependants

It's a built in feature. Under View - Toolbars - Formula auditing. Select all
the cells (Ctrl+A) and then click the "Trace Dependents" button. If there are
no dependents, a message will appear. Otherwise, arrows will appear showing
dependencies (if to other sheets, shows an arrow going to a table icon).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mitch Powell" wrote:

I delete what I think is a standalone sheet only to find that other places in
the workbook sepend on cells in the sheet. Does anyone know of a utility or
add-in that will search a workbook and identify any references to a sheet?