Office Settings & Configuration

Fix Microsoft 365 Excel Analyze Data Not Set Up Properly

Bushra ParveenBushra Parveen Nov 12, 2026 869 views

Question details

The user needs to restore the Analyze Data feature in Microsoft 365 Excel after it reports that the feature is not set up properly.

Fix Microsoft 365 Excel Analyze Data Not Set Up Properly
Product
Microsoft Excel for Microsoft 365
Device & OS
Windows
Scenario
The user selects Analyze Data in Excel to generate insights, charts, or summaries from worksheet data.
Observed behavior
Excel displays the message: “We can't start this feature because it isn't set up properly.”
Before you start

Confirm that you are connected to the internet and signed in to Excel with the Microsoft 365 account that includes your Office subscription. Open a workbook containing a structured data range with column headers before testing Analyze Data again.

Solution 1Recommended

Update Excel and enable connected experiences

Use this option first when Analyze Data is unavailable after an Office update, account change, or privacy-setting change.

Analyze Data is a built-in Microsoft 365 Excel feature. It relies on supported Excel versions and connected experiences, so it can fail when Office is outdated or optional connected experiences are disabled.

1
Check for Office updates

In Excel, go to File > Account > Update Options > Update Now. Allow Microsoft 365 to install available updates, then restart Excel.

2
Verify your Microsoft 365 account

Go to File > Account and check the account shown under User Information and Product Information. Select Sign out and then Sign in if you need to switch to the Microsoft 365 account with your active subscription.

3
Turn on connected experiences

Go to File > Account > Account Privacy > Manage Settings. Enable Optional connected experiences, then select OK and restart Excel.

4
Test Analyze Data again

Select a cell inside your data range, then open the Home tab and select Analyze Data. If prompted, select a suggested analysis to confirm the feature can load.

Update Excel and enable connected experiences
Organization-managed devices: If the connected-experiences setting is unavailable or locked, your work or school administrator may have disabled it through Microsoft 365 policy.
Free Microsoft Office alternative

Analyze and organize spreadsheet data with WPS Spreadsheet

If Microsoft 365 settings or organization policies prevent you from using Excel features, WPS Office provides a free, lightweight office suite with a familiar spreadsheet interface. Open existing Excel files in WPS Spreadsheet and continue sorting, filtering, calculating, and visualizing your data with an easy migration path.

  1. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheet from the WPS Office home screen.
  2. 2. Open the Excel workbook: Select Open and choose your existing .xlsx or .xls workbook to continue working with the same spreadsheet data.
  3. 3. Prepare the data range: Make sure the first row contains clear column headers, then select the data range you want to review.
  4. 4. Create an analysis view: Use the Data and Insert tabs to sort or filter records, create a chart, or build a pivot-style summary for your worksheet.
Open and edit Microsoft Excel .xlsx, .xls, and .csv files with strong format compatibility.Use spreadsheet formulas, sorting, filtering, pivot-style analysis, and charts to explore worksheet data.Work in a familiar ribbon-based interface designed for an easy transition from Microsoft Excel.Install a free, lightweight office suite for everyday document and spreadsheet tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say Analyze Data is not set up properly?

The message can appear when Microsoft 365 is out of date, Excel is signed in with the wrong account, optional connected experiences are disabled, Office files are damaged, or an organization policy blocks the feature.

Where can I enable connected experiences in Excel?

Go to File > Account > Account Privacy > Manage Settings, then enable Optional connected experiences if the setting is available. Restart Excel after changing it.

Does Analyze Data require a separate Excel add-in?

No. Analyze Data is built into supported Microsoft 365 versions of Excel and does not normally require a separate add-in installation.

How do I repair Microsoft 365 when Analyze Data will not start?

In Windows, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu > Modify, and run Quick Repair. Use Online Repair if Quick Repair does not resolve the issue.

Why is the connected experiences setting grayed out in Excel?

A work or school administrator may manage privacy and connected-experience settings through Microsoft 365 policy. Contact the organization administrator to check whether Analyze Data or connected experiences are restricted.