We suggest you to review the topics below. Possible you'll find answer to your questions about Dependency Auditor
command in the Dependency Auditor
displays inputs of range, which is currently selected in Excel.
To understand how this feature works - just do the following:
- create new workbook
on Sheet1 enter following formulas
select cell A4 and press Show Inputs button on Dependency Auditor toolbar.
You will see following list of input cells for A4