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)
The Microsoft Query option that used to be under "Get Data/From Other Sources" has disappeared. I can edit existing queries by right clicking on the query table, but I can no longer create new queries without the Microsoft Query option. I have tried repairing Office 365 but it is still not there. I have 64 bit Office. I recently downloaded Power BI desktop and used Power Query, could this have something to do with my Microsoft Query option disappearing from Excel?
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 worked for me:
Options > Data > Check the 'From Microsoft Query (Legacy)" box
Then its under Get Data > Legacy Wizards
You are my hero, Sir! I check with your procedure and it worked fine after closing all excel instances and open a new window.
Thank you so much!!
Great solution Jordan
MS, please stop breaking good things
Microsofts infinite wizdom and constant need to make everyone do things the way they want have moved one of the most commonly used functions in Excel to "Legacy". Yes you can add these as others described but WHY! I am so tired of big corps dictating how we use the product we purchased.
This is bug for newest version. From Microsoft Query option is missed.
You may rollback office update as workaround.
How to revert to an earlier version of Office - Microsoft Support
You may also raise it to Microsoft. Hope Micro soft will fix it soon.
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