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
Thank you, thank you, thank you!!
It does come back as an option but crashes Excel when you try and use it.