Installing the Analysis Toolpak Add-in for Excel

Summary

The Excel Analysis Toolpak can be enabled even though Office 365 prevents individual acquisition of Office Add-ins

Body

Issue/Question

Please enable the Analysis Toolpak add-in for Excel

Error: Sorry, Office 365 has been configured to prevent individual acquisition of Office Add-ins

Environment

  • Excel

Cause

The Microsoft Analysis Toolpak is an Excel add-in managed separately from Office add-ins

Resolution

  • Follow the instructions to Load the Analysis ToolPak in Excel
    • The instructions are included for both Windows and macOS
    • The instructions indicate you may also need to enable Analysis ToolPak - VBA

Details

Details

Article ID: 5837
Created
Tue 12/1/20 4:08 PM
Modified
Fri 6/23/23 1:10 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated