trace dependents

[JBoulton]

Tools/Formula Auditing/Trace Dependents produces a dotted line with an arrow
to a sheet icon. How do I find which workbook/worksheet has the dependent?
--
Jim

[Duke Carey]

Double click on the dotted line

"JBoulton" wrote:

> Tools/Formula Auditing/Trace Dependents produces a dotted line with an arrow
> to a sheet icon. How do I find which workbook/worksheet has the dependent?
> --
> Jim

[JBoulton]

That was too easy! Thanks for the hint.
--
Jim


"Duke Carey" wrote:

> Double click on the dotted line
>
> "JBoulton" wrote:
>
> > Tools/Formula Auditing/Trace Dependents produces a dotted line with an arrow
> > to a sheet icon. How do I find which workbook/worksheet has the dependent?
> > --
> > Jim