Power Formula Auditing: The Power Tool for every Excel User

File
tab, click 
Options
, and then click the 
Add-Ins
category.
·
In the 
Manage
box, click 
Excel Add-ins
, and then click 
Go
.
·
The 
Add-Ins
dialog box appears.
·
In the 
Add-Ins available
box, 
uncheck
the check box next to the add-in that you
want to deactivate, and then click 
OK
.
For more general and detailed information about add-ins and steps to add or
remove add-ins to your spreadsheet, please see this link from Microsoft
support (
Add or remove add-ins
).

---

Appendix C. PowerFormulaAudit Menu
The PowerFormulaAudit menu is shown below.
Figure 47.. PowerFormulaAudit Menu
PowerFormulaAudit has the following menu buttons, listed from left to right as
shown in the above figure.
Multi-Precedent
Excel’s “Trace Precedents” works only when one cell is selected, Multi-
Precedent works on any number of selected cells, e.g., a single cell, a row /
column of cells, a block of cells, or even an entire worksheet. Where
applicable, every click shows the next level of precedents.
Since this function works on many selected cells at a time, the precedents may
not be strictly one level up. The reason is that the selected cells may already
have a few levels of precedents. In the case where an entire worksheet is
selected, this function will draw all the precedent arrows in the worksheet.
Multi-Dependent
This works in the same way as Excel’s “Trace Dependents”, but allow many
cells to be selected. Each click shows the next level of dependents.

---

As in the case of multi-precedents, the function does not go strictly by one
level of dependents. The reason is that the selected cells may already have a
few levels of dependents. When an entire worksheet is selected, this function
draws all the dependent arrows.
As illustrated earlier, dependent arrows may look different from precedent
arrows (particularly for box arrows).