We suggest you to review the topics below. Possible you'll find answer to your questions about Dependency Auditor
Using Dependency Auditor
If you have Excel 2007 and higher (2010/2013):
If you have Excel 2003:
For fast access they are duplicated on Dependency Auditor toolbar:
All commands use range, which is currently selected in workbook. They have
similar and user friendly interface, which shows information in a tree-form.