Dependency Auditor uses state-of-the-art algorithms
to analyze and display dependencies and debug
calculations in Microsoft Excel. It has various
features, which will help you to audit your
spreadsheet and analyze all data-flows. Dependency
Auditor has simple and clear interface.
Dependency Auditor shows hidden dependents and
precedents, produced by OFFSET and INDIRECT
functions. It shows actual dependencies in your
model!
This add-in will save your time in analyzing
workbook structure and debugging calculations in
your spreadsheet. Armed with Dependency Auditor, the
user is able to solve the most common problems that
you encounter on a daily basis.
Tasks solved with Dependency Auditor:
* How specific cell impacts to other cells?
* Export list of dependencies to worksheet or text
file for future use or printing.
* How selected cell depends from input of your
model?
* Find indirect dependencies produced by reference
functions.
* Numbers in your spreadsheet model are wrong.
* Complex formula returns unexpected value.
* Why output cell contains error value?
* Review all errors in workbook in single list.
* Transpose selected range