Dependency Auditor Window
Just expand a branch too see next level of dependency.
![Select Cell](./images/single.webp)
single cell. Expand this branch too see its dependents\precedents.
![Select Range](./images/range.webp)
range of cells. Expand it to see each cell separately.
![Select Defined Name](./images/name.webp)
constant value, entered into Names Collection. For example, you can define name PI=3.14159265 and use it in formulas.
![Select External Link](./images/external.webp)
range from other workbook. It could not
be expanded, but you can trace dependents\precedents for this range in a
separate window using context menu.
![Hidden Dependency - Single Cell](./images/single_hid.webp)
single cell (hidden) added as a result of using OFFSET or INDIRECT functions.
![Hidden Dependency - Range](./images/range_hid.webp)
range of cells (hidden) added as a result of using OFFSET or INDIRECT functions.