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)
I have updated my options by going to File/Options/Data and marking the flag "from Microsoft Query Legacy". However when I select the legacy options under Data/Get Data/Legacy Wizards, MS Query is in the list however it's grayed out. When I select the grayed out option, Excel goes into a wait state and nothing happens. I cannot figure out how to have the option enabled so it works.
I also don't have the option for "from Microsoft Query" in my "all commands" when trying to customize the ribbon.
As a alternative attempt at solving the issue, I completely reinstalled office, uninstalled using the command prompt application SaRACmd, deleting the cache folders, deleting registry keys, etc. I attempted to completely remove office from my computer. I reinstalled and have the same issue as described above.
So the issue is how do I get the MS Query app enabled again? I did find the executable for MS query and can run a query standalone but cannot send the results directly to Excel. Please advise. Thanks.
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.
From your description, It seems other software makes your From Microsoft Query stuck. You may try stopping other software.
You may also try creating a query from PBI and copy the query code to Excel on a new blank query.
Here is mine.
Thanks for responding. I don't know what you mean by stopping other software. My computer has the legacy wizard just as you show (microsoft query) but it's grayed out. When I select, Excel goes into a wait state and shows "waiting for data to be returned from Microsoft query" as shown below. Why is MS Query grayed out? It's installed as I can ran it stand alone but when running stand alone, I cannot export the data directly to Excel. Please advise. Thanks.
I'd suggest you create a support ticket to Microsoft.
Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.
Get support - Microsoft 365 admin | Microsoft Learn
About how to find the admin in your organization, you can refer to How do I find my Office 365 admin
I also have exactly the same issue , is there any update from Microsoft ?
Check this one. Then you can use it.