 |
Welcome |
|
Requirements |
|
Copyright and License |
|
Registration |
|
Limitations in Trial Version |
 |
Using Dependency Auditor |
|
Using Dependency Auditor |
|
Dependency Auditor Window |
|
Error tracing |
|
Context Menu |
|
Find cell/range |
|
Hotkeys |
|
Use Dependency Auditor engine from Visual Basic macro |
|
Commands |
|
Show Dependents |
|
Show Precedents |
|
Show Inputs |
|
Show Errors |
|
Trace Error |
|
Evaluate Formula |
|
Filter by color |
|
Refresh Contents |
|
How to ... |
|
Does one cell depend from another? |
|
Why cell contains error value? |
|
Formula produces unexpected result. |
|
Transfer your license to another PC |
|
Do you need more help? |
Dependency Auditor Window.
Dependency Auditor shows all dependent or precedent cells in hierarchical form:
Just expand a branch too see next level of dependency.
single cell. Expand this branch too
see its dependents\precedents.
range of cells. Expand it to see each
cell separately.
constant value, entered into Names Collection.
For example, you can define name PI=3.14159265 and use it in formulas.
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.
single cell (hidden) added as a result of using OFFSET or INDIRECT functions.
single cell. Expand this branch too
see its dependents\precedents. range of cells. Expand it to see each
cell separately. constant value, entered into Names Collection.
For example, you can define name PI=3.14159265 and use it in formulas.
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.
single cell (hidden) added as a result of using OFFSET or INDIRECT functions.