ExcelBanter - trace dependents

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - trace dependents (https://www.excelbanter.com/excel-worksheet-functions/26945-trace-dependents.html)

JBoulton

trace dependents

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

All times are GMT +1. The time now is 02:20 AM.