Fix a Missing Analysis ToolPak Command in Excel
Question details
Restore the Data Analysis command when the Analysis ToolPak is selected but the command is missing from Excel’s Data tab.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to use the Analysis ToolPak from Excel’s Data tab.
- Observed behavior
- The Analysis ToolPak checkbox remains selected, but the Data Analysis command is not visible on the Data tab.
Open the Excel desktop app and check the Data tab for the Data Analysis command, typically in the Analysis group. The menu paths below apply to Excel for Windows.
Reset the Analysis ToolPak add-in in Excel
Use this first when the ToolPak is already selected but its command is missing.
In Excel, select File > Options > Add-ins.
In the Manage box, select Excel Add-ins and click Go. Clear the Analysis ToolPak checkbox and click OK.
Return to File > Options > Add-ins, select Excel Add-ins in the Manage box, and click Go. Select Analysis ToolPak and click OK.
Close and reopen Excel, then select the Data tab and look for Data Analysis.

Check for conflicting Excel add-ins
Use this if resetting the ToolPak does not restore the command.
Run an Office Quick Repair on Windows
Use Quick Repair if the command is still missing after checking the add-ins.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Excel format compatibility helps you move existing files into WPS, although it does not repair Excel’s Analysis ToolPak.

Frequently Asked Questions
Where should the Data Analysis command appear in Excel?
In the Excel desktop app, select the Data tab and look for Data Analysis, typically in the Analysis group.
How do I turn the Analysis ToolPak off and on again?
Go to File > Options > Add-ins, select Excel Add-ins in the Manage box, and click Go. Clear Analysis ToolPak and click OK, then reopen the dialog, select it again, and click OK.
Could another add-in hide the Data Analysis command?
An add-in conflict may be involved. Temporarily disable other Excel add-ins through File > Options > Add-ins > Excel Add-ins > Go, restart Excel, and check the Data tab.
What should I try if resetting the ToolPak does not work?
On Windows, close Excel and open Settings > Apps > Installed apps or Apps & Features. Find Microsoft Office or Microsoft 365, choose Modify, and run Quick Repair.




