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?
|