Enable the Analysis ToolPak in Desktop Excel
Question details
Determine whether a university account is using Excel for the web and enable the Analysis ToolPak on a supported desktop installation.

- Product
- Microsoft Excel Analysis ToolPak
- Device & OS
- not provided
- Scenario
- A university user wants to access the Analysis ToolPak but cannot find the desktop add-in settings.
- Observed behavior
- The available settings may show regional options without an Add-ins section, suggesting that the workbook is open in Excel for the web.
Check whether Excel is open in a web browser or as a desktop application. Confirm that your university account includes access to a supported desktop version of Excel.
Enable the Analysis ToolPak in Excel for Windows
Use this method when the workbook is open in the desktop version of Excel for Windows.
The Analysis ToolPak is not available in Excel for the web. The add-in settings below are specific to desktop Excel for Windows.
Launch the Excel desktop application and open your workbook. If the workbook is in your browser, look for Open in Desktop App.
In Excel, select File > Options > Add-ins.
At the bottom of the Add-ins window, select Excel Add-ins in the Manage box and click Go. Select Analysis ToolPak and click OK.
Open the Data tab and look for Data Analysis.

Enable the Analysis ToolPak in Excel for Mac
Use the Mac-specific add-in menu when working in desktop Excel for Mac.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS with minimal disruption. It does not enable Excel's Analysis ToolPak.

Frequently Asked Questions
Can I enable the Analysis ToolPak in Excel for the web?
No. Open the workbook in a supported desktop version of Excel to load the Analysis ToolPak.
How can I tell if I am using Excel for the web?
If your workbook is open inside a web browser, you are using Excel for the web. Look for an Open in Desktop App option to switch to an installed version.
Where is Data Analysis after I enable the ToolPak?
In desktop Excel, open the Data tab and look for Data Analysis. If it is missing, check that Analysis ToolPak is selected in the add-ins menu.
What if my university account does not let me install desktop Excel?
Contact your university administrator to check whether your license includes desktop Excel and whether installation is permitted on your device.
Can WPS Office enable Excel's Analysis ToolPak?
No. The ToolPak is an Excel add-in. WPS Spreadsheets can open Excel files and provide spreadsheet functions, but it does not enable the Excel add-in.




