We suggest you to review the topics below. Possible you'll find answer to your questions about
Dependency Auditor here.
Show Precedents
Show Precedents command in the
Dependency Auditor,
displays precedents 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
A1 =1
A2 =A1+1
A3 =A2+A1+1
A4 =A1+A2+A3+1
-
select cell A4 and press Show Precedents button on Dependency Auditor toolbar.
you will see following list of precedents for A4