Does Excel Analyze Data Require Connected Services? How to Fix Missing Feature
Question details
The user wants to know if Excel's Analyze Data tool requires Connected Services and how to locate or restore the command if it is missing from the interface.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to use the Analyze Data feature in Excel but finding it unavailable, missing, or grayed out on the Home tab.
- Observed behavior
- The Analyze Data command is not visible on the Home tab, raising concerns about whether Connected Services must be enabled or if organizational policies are blocking it.
Verify that you have an active Microsoft 365 subscription, as the Analyze Data feature is not supported in older standalone versions like Excel 2016 or 2019.
Add Analyze Data to the Home Tab via Ribbon Customization
If the Analyze Data button is simply hidden from your view, you can easily restore it by customizing the Excel Ribbon.
In most cases, the Analyze Data feature does not require Optional Connected Experiences to be turned on. If your version supports it but you cannot see it, it may have been accidentally removed from your Ribbon.
Launch Microsoft Excel and navigate to File > Options at the bottom left of your screen.
In the Excel Options dialog box, click on 'Customize Ribbon' from the left-hand menu.
Under the 'Choose commands from' dropdown menu, select 'All Commands'. Scroll down the alphabetical list until you find 'Analyze Data'.
In the right panel, expand the 'Home' tab, click 'New Group', then select the 'Analyze Data' command on the left and click the 'Add' button. Click 'OK' to save your changes.

Verify Account Licensing and Organizational Policies
Sometimes the feature is disabled by IT administrators or requires a specific Microsoft 365 license.
Repair Your Microsoft Office Installation
If your version supports it and policies allow it, but it's still missing, a corrupted Office installation might be the cause.
Use WPS Office for Powerful and Free Data Analysis
If you are struggling with missing features, complex ribbon settings, or restrictive licensing in Microsoft Excel, WPS Spreadsheet offers a robust, lightweight, and completely free alternative. It provides comprehensive data analysis tools without requiring complex connected service configurations.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Data: Launch WPS Spreadsheet and easily open your existing Excel (.xlsx) files without losing formatting.
- 3. Analyze Data Quickly: Navigate to the Data tab to access powerful analysis tools like PivotTables, Consolidation, and What-If Analysis instantly.

Frequently Asked Questions
Why is the Analyze Data button grayed out in Excel?
This usually happens if you are editing a file in compatibility mode (.xls format), if your data contains merged cells, or if you are not currently signed into your Microsoft 365 account. Saving the file as a modern .xlsx file and removing merged cells usually fixes this.
Do I need internet access to use Analyze Data in Excel?
Yes. Even though you may not need to explicitly check 'Optional Connected Services' in your privacy settings for all versions, the Analyze Data feature is cloud-backed and requires an active internet connection to analyze your data models.
Is Analyze Data available in Excel 2019 or Excel 2021?
No, the Analyze Data feature is exclusive to Microsoft 365 subscribers and Excel for the web. Standalone perpetual versions like Excel 2019 and 2021 do not include this tool.
How do I turn on Connected Services in Microsoft Office?
To manage these settings, open Excel, go to File > Account > Account Privacy, and click on 'Manage Settings'. Scroll down to 'Optional connected experiences' and check the box to turn them on.




