Analysis ToolPak Missing from Excel

Summary

Activating the Analysis ToolPak in Excel.

Body

Issue:  Analysis ToolPak is not available in Excel, I get a message that the Office Store is blocked when I try to install it.

Environment:  Excel desktop application

Resolution:  Enable the Analysis ToolPak add-in from Excel Options

Excel on Windows

1. Click the "File" button in the upper left corner.
2. Click the "Options" menu in the left sidebar
​​​​​​3. ​Click the "Add-ins" menu and click the "Go" button next to the "Manage Excel Add-ins" drop-down near the bottom of the window

Uploaded Image (Thumbnail)

 

 

 

 



4. Check the box next to "Analysis ToolPak" and click OK

Uploaded Image (Thumbnail)

5. Restart Excel, and the Data Analysis ToolPak will be available under the "Data" tab

Excel on macOS

1. Click the "Tools" button in menu bar (top of the screen)

2. Click the "Excel Add-ins..." button

Uploaded Image (Thumbnail)

3. Check the box next to "Analysis ToolPak" and click OK

Uploaded Image (Thumbnail)

4. Restart Excel, and the Data Analysis ToolPak will be available under the "Data" tab

Details

Details

Article ID: 163081
Created
Wed 12/4/24 3:39 PM
Modified
Wed 12/18/24 1:05 PM