Power Formula Auditing: The Power Tool for every Excel User

File
tab, click 
Options
, and then click the 
Add-Ins
category.
o
In the 
Manage
box, click 
Excel Add-ins
, and then click 
Go
.
o
The 
Add-Ins
dialog box appears.
o
Browse
to the directory where you save
.
PowerFormulaAudit_1.0.xlam.
Select the file.
o
PowerFormulaAudit will show up in 
Add-Ins available
box.
·
You may need to activate the add-in with the following steps:
o
Click the 
File
tab, click 
Options
, and then click the 
Add-Ins
category.
o
In the 
Manage
box, click 
Excel Add-ins
, and then click 
Go
.
o
The 
Add-Ins
dialog box appears.
o
In the 
Add-Ins available
box, select the check box next to the add-in that you
want to activate, and then click 
OK
.
·
Close Excel. Do not delete the file for PowerFormulaAudit.
·
You can use Excel as per normal. The commands from Power Formula
Audit are in the menu for you to use with any Excel file.
The first time a Power Formula Audit button is used in a file, Excel may
prompt you to enable the macros.

---

The addition steps are further illustrated with the following screenshots:
Figure 45. File / Options /Add-ins Screenshot
Figure 46. After clicking "Go" from the previous screenshot
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 B. How to uninstall PowerFormulaAudit from
Excel?
The add-ins will be there until you remove it. A simple way to remove
PowerFormulaAudit is to delete the PowerFormulaAudit file from the
directory. If the file is moved to another directory, Excel will not be able to
find the PowerFormulaAudit functions.
Another way is to deactivate the add-in, which will also remove the menu for
power formula audit. The steps are similar to the activation steps in Appendix
A.
The steps to deactivate are:
·
Click the