Office Settings & Configuration

Does Excel Analyze Data Require Connected Services? How to Fix Missing Feature

Amos GikundaAmos Gikunda Oct 12, 2026 870 views

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.

Does Excel Analyze Data Require Connected Services?
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

Launch Microsoft Excel and navigate to File > Options at the bottom left of your screen.

2
Access Customize Ribbon

In the Excel Options dialog box, click on 'Customize Ribbon' from the left-hand menu.

3
Locate the Command

Under the 'Choose commands from' dropdown menu, select 'All Commands'. Scroll down the alphabetical list until you find 'Analyze Data'.

4
Add to Home Tab

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.

Add Analyze Data to the Home Tab via Ribbon Customization
Command Restored: You should now see the Analyze Data button appear on the far right of your Home tab.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open Your Data: Launch WPS Spreadsheet and easily open your existing Excel (.xlsx) files without losing formatting.
  3. 3. Analyze Data Quickly: Navigate to the Data tab to access powerful analysis tools like PivotTables, Consolidation, and What-If Analysis instantly.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) for seamless migration.Rich built-in data analysis tools, PivotTables, and advanced charting.Lightweight installation with no confusing 'Connected Services' dependencies.Completely free to use with a familiar, easy-to-navigate user interface.
microsoft office alternative - wps office

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.