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.
This is not a fix, I have multiple users and that is not a viable option, I found if you switch to another user login then switch back it will work again.
While this is a fix either it's easier then creating another user account...
I have tried all of the above options to no avail. MSQuery still does not work.
Thanks but that is not my problem, Msquery is available but when I click it excel freezes and I have to close excel.
Ok I have finally figured out the issue as my new profile started playing up again .
It is actually to do with OneDrive and the Microsoft Sharepoint task . C:\Program Files\Microsoft OneDrive\24.166.0818.0002 is the version I have .
If you go into Task Manager whilet excel is hanging and Kill this task it MS Query will work again .
Yes it is a workaround , but atleast I have narrowed down the offending program .
Thanks Adam - impressive find. Appreciate the feedback.