Office Settings & Configuration

Fix a Missing Analysis ToolPak Command in Excel

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

Restore the Data Analysis command when the Analysis ToolPak is selected but the command is missing from Excel’s Data tab.

Fix a Missing Analysis ToolPak Command in Excel
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.
Before you start

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.

Solution 1Recommended

Reset the Analysis ToolPak add-in in Excel

Use this first when the ToolPak is already selected but its command is missing.

1
Open add-in settings

In Excel, select File > Options > Add-ins.

2
Clear the ToolPak

In the Manage box, select Excel Add-ins and click Go. Clear the Analysis ToolPak checkbox and click OK.

3
Enable it again

Return to File > Options > Add-ins, select Excel Add-ins in the Manage box, and click Go. Select Analysis ToolPak and click OK.

4
Restart Excel

Close and reopen Excel, then select the Data tab and look for Data Analysis.

Reset the Analysis ToolPak add-in in Excel
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesWork with spreadsheet data using formulas and chartsUse a familiar interface that makes switching easierGet a free, lightweight office suite
microsoft office alternative - wps office

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.