Tracking down dependent cells 1

[macajm]

Does anyone know how to find dependent cells after using the "Trace dependents" button on the Auditing toolbar, when the dependent cells are in another worksheet? (It's fine if they are on the current worksheet, as Excel shows arrows, but if on another sheet, just an icon appears)

 

[ProjEngKLS]

I've never messed around with this before, but I tried it to see. I got an arrow from the source cell pointing to a little spreadsheet looking icon. I found that in double-clicking the arrow (arrowhead or end dot or line in between) a GOTO dialog opens giving you the path to the dependent cell.

Hope this helps.

 

[macajm]

Thanks ProjEngKLS - That's the trick I was looking for.