Fix the Excel Analyze Data Setup Error in Microsoft 365
Question details
The user needs to restore the Analyze Data feature after Excel reports that the feature is not set up properly.

- Product
- Microsoft Excel in Microsoft 365 or Microsoft Office
- Device & OS
- Windows
- Scenario
- The user tries to start Analyze Data in an Excel workbook.
- Observed behavior
- Excel displays the message “We can't start this feature because it isn't set up properly.”
Close Excel and all other Microsoft Office apps before starting a repair. Confirm that you are signed in with the Microsoft 365 account that includes your Excel subscription.
Run an Online Repair for Microsoft 365 or Microsoft Office
Use this option when Analyze Data previously worked or Excel may have an incomplete or damaged installation.
Online Repair reinstalls Microsoft Office components and can restore cloud-connected features such as Analyze Data. You will need an internet connection and may need to sign in to Office again afterward.
Press Windows + I to open Settings, then select Apps > Installed apps. On some Windows versions, select Apps > Apps & features.
Locate Microsoft 365 or Microsoft Office in the app list, select the three-dot menu next to it, and choose Modify.
Select Online Repair, choose Repair, and follow the on-screen prompts to complete the repair process.
Restart Windows if prompted, open Excel, then select a data range and go to Home > Analyze Data to check whether the feature opens.

Check Analyze Data availability and connected experience settings
Use this option if Office repair finishes successfully but Analyze Data is still unavailable or cannot start.
Use WPS Spreadsheet for Everyday Excel Workbook Analysis
If Microsoft Excel features are unavailable because of a Microsoft 365 installation, license, or organization setting, WPS Office provides a free, lightweight, and familiar office suite for working with spreadsheets. Open and edit your existing Excel files with a familiar ribbon-based interface and migrate your work smoothly.

Frequently Asked Questions
Why does Excel say Analyze Data is not set up properly?
The message commonly appears when Microsoft Office installation files are incomplete or damaged. It can also occur when your Excel license, connected experiences settings, or organization policy does not allow Analyze Data.
Where do I repair Microsoft 365 on Windows?
Open Windows Settings > Apps > Installed apps, find Microsoft 365 or Microsoft Office, select its three-dot menu, choose Modify, and then select Online Repair.
Does Quick Repair fix the Analyze Data setup error?
Quick Repair may resolve minor local issues, but Online Repair is the better choice for this error because it reinstalls Office components from Microsoft.
Why is the Analyze Data button missing from the Home tab?
The button may be unavailable in your Excel version or subscription, or it may be disabled by your organization. Check File > Account for your license details and ask your Microsoft 365 administrator about policy restrictions.
Do connected experiences affect Excel Analyze Data?
Yes. Analyze Data can rely on Microsoft connected experiences. In Excel, review File > Account > Account Privacy > Manage Settings and enable optional connected experiences if your organization allows it.




