MS Query not loading in Excel

Question

Not able to load MS Query in Microsoft Excel for Microsoft 365 MSO (Version 2212 Build 16.0.15928.20278) 64-bit, when logging in withM365 accounts. This is also true on different update versions of Excel and Win10. If opening on a non 365 sign in it will work.

The issue is that it does not display the choose data source prompt when MS query is selected to be open

It will instead do nothing for around 30 seconds and the display the message: Microsoft Query could not be started because it isn't Installed. You can install the query by running the installation program you used to install Office or Excel. The Query option is in the Office Tools category.

The MS Query program itself always loads in the background when it works on the non 365 accounts and also when the message comes up saying it is not installed with using a 365 account.

The MSQRY32.exe is located within C:\Program Files\Microsoft Office\root\Office16

We have a Win11 test device and it works no problem with Excel using a M365 account. Have tried repairing Office, new device builds etc. Something with using M365 accounts not allowing the choose data source prompt to load?

Answer 1

Hi @David_O_23,

Did the Microsoft Query work fine before?

I suggest you try to open the Excel in safe mode, running the following command: Press Win + R, type "excel /safe" in the blank box, press Enter. If it works fine in safe mode, please check the add-ins in your excel and disable them.

Then, please go to the following path to run MSQRY32.EXE for a test.

• 32 bit   C:\Program Files (x86)\Microsoft Office\root\Office16
• 64 bit   C:\Program Files\Microsoft Office\root\Office16

After testing, if it works fine I suggest you try to use the Administrator profile to login and check if this problem is related to profile permission.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @David_O_23,

you need to check you GPO settings, maybe you are blocking: Dynamic Data Exchange (DDE)? If yes Microsoft query will not work.

Answer 3

It's more like the puppet services of fraud experiments