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
4. Check the box next to "Analysis ToolPak" and click OK
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
3. Check the box next to "Analysis ToolPak" and click OK
4. Restart Excel, and the Data Analysis ToolPak will be available under the "Data" tab