Share via

“Analyze Data” button in O365 Excel is grey.

Anonymous
2024-02-26T09:03:56+00:00

Issue: in Excel, “Analyze Data” button can be added via "File > Options > Customize the Ribbon", but it is grey and cannot be used.

Function description of the button: https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4

Office version: Semi-Annual Enterprise Channel (Version 2308 Build 16.0.16731.20496)

OS version: Windows 10 Enterprise 22H2 (build 19045.4046)

Others:

Re-open Excel and restart computer > not works.

Re-install O365 App > not works.

If I "sign out" Microsoft account in Excel, “Analyze Data” button can be clicked and used, but Excel will prompt to "sign in" at next opening. After "sign in" again, the button becomes grey again.

Error screenshot:

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-02-26T13:30:25+00:00

    Analyze Data is one of the connected experiences. It could be disabled by your Admin.

    Connected experiences in Office - Deploy Office | Microsoft Learn

    Image

    0 comments