Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Trace dependants/precedents from another worksheet | Excel Discussion (Misc queries) | |||
Can I trace dependants for a multiple selection? | Excel Discussion (Misc queries) | |||
Trace Dependants Not Working... | Excel Worksheet Functions | |||
Trace Dependants | Excel Discussion (Misc queries) |