-
Click the File tab, click Options, and after that click the Add-Ins classification.
-
In the Manage box, select Excel Add-ins and then click Go.
If you’re utilizing Excel for Mac, in the file menu go to Tools > Excel Add-ins.
-
In the Add-Ins box, examine the Analysis ToolPak check box, and then click OK.
-
If Analysis ToolPak is not noted in the Add-Ins readily available box, click Browse to locate it.
-
If you are prompted that the Analysis ToolPak is not currently set up on your computer system, click Yes to install it.
-
Note: To include Visual Basic for Application (VBA) works for the Analysis ToolPak, you can fill the Analysis ToolPak – VBA Add-in the very same way that you load the Analysis ToolPak. In the Add-ins available box, choose the Analysis ToolPak – VBA check box.
The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you set up Microsoft Workplace or Excel.
