Data Analysis is not showing up after I activated the feature

Reload the Analysis ToolPak in Excel’s add-in manager; this feature is installed locally, so changing Microsoft accounts normally does not reload its missing ribbon command.

Reload the Analysis ToolPak

1. In Excel, open File → Options → Add-ins.
2. At the bottom, set Manage to Excel Add-ins, then select Go.
3. If Analysis ToolPak is already checked:
   • Clear its checkbox and select OK.
   • Fully exit every Excel window.
   • Reopen Excel and return to File → Options → Add-ins → Manage: Excel Add-ins → Go.
   • Check Analysis ToolPak and select OK.
4. If Excel says the ToolPak is not installed, select Yes to install it.
5. Open the Data tab. The expected result is Data Analysis in the Analysis group, matching the button in your screenshot. The official procedure confirms that this is the add-in and location used for the command.^1^ Reloading it by unchecking, exiting, and enabling it again is the applicable next step when it already appears activated.^2^

Analysis ToolPak/Data Analysis is different from Microsoft 365’s Analyze Data feature. Your screenshot shows the former.

If the command is still absent

Temporarily test for a ribbon conflict:

1. Go to File → Options → Add-ins.
2. Set Manage to COM Add-ins, then select Go.
3. Record which third-party add-ins are enabled, temporarily clear their checkboxes, and restart Excel.
4. Check Data → Analysis → Data Analysis again.
5. If it appears, re-enable the COM add-ins one at a time to identify the conflict.^3^

Repair Office if reloading does not work

On Windows 11:

1. Right-click Start → Installed apps.
2. Find Microsoft 365 or Office.
3. Select the … menu → Modify.
4. For a Click-to-Run installation, choose Online Repair → Repair.
5. Restart Windows afterward, open Excel, and enable the Analysis ToolPak again.

On Windows 10, use Start → Apps and Features, select Microsoft 365 or Office, and choose Modify. Online Repair repairs the entire Office installation and is more comprehensive than Quick Repair.^4^

Managed work or school computer

If the command remains missing after Online Repair, ask the Microsoft 365 administrator whether Excel commands or macros are restricted by organizational policy. Administrators can disable ribbon commands through Group Policy.^5^

For a managed Microsoft 365 tenant, an administrator can open Microsoft 365 Admin Center → Support → Help & Support and submit a service request.^6^ For an unmanaged/personal installation that still fails after Online Repair, contact Microsoft Support and include the Excel version shown under File → Account → About Excel, plus a screenshot of the Excel Add-ins dialog showing that Analysis ToolPak is enabled.

References

1. Use the Analysis ToolPak to perform complex data analysis
2. In Excel 365, Windows 11, 64-bit the Analyzed Data window opens but remains gray - Microsoft Q&A
3. Excel Analysis TookPak and Solver Add-in - Microsoft Q&A
4. Repair an Office application | Microsoft Support
5. Commands on the Ribbon are disabled by the administrator | Microsoft Support
6. Solver and Data Analysis Add-ins Not Appearing in Excel Ribbon - Microsoft Q&A