This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Hi, our 365 is on enterprise for Business. I think I have narrowed the issue down with the Trust Centre External content. By policy we have the "enable dynamic data exchange server lookup" not enabled. Checking on this to see if enabling it will resolve it.
Though Power query can use DDE feature, it will not affect the useage of power query.
Windows provides several methods for transferring data between applications. One method is to use the Dynamic Data Exchange (DDE) protocol. The DDE protocol is a set of messages and guidelines. It sends messages between applications that share data and uses shared memory to exchange data between applications. Applications can use the DDE protocol for one-time data transfers and for continuous exchanges in which applications send updates to one another as new data becomes available.
Hi David,
Greetings! Thank you for posting to Microsoft Community.
It could be your version installed on your machine doesn't match the subscription of M365 account.
Uninstall Office automatically - Microsoft Support using offscrub tool and Download and install or reinstall Microsoft 365 or Office 2021 on a PC or Mac - Microsoft Support
Best Regards,
Snow Lu