Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Create Data Type option missing from Excel's Power Query Editor
![](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)
Anonymous
Hello,
I am having an issue with the Power Query Editor. Mainly that it is missing the option to "Create Data Type":
I tried the basic troubleshooting options: QuickRepair, complete re-install using the cleanup tool but none of that seems to matter. I found a previous question: https://answers.microsoft.com/en-us/msoffice/forum/all/missing-create-a-data-type-option-excel/4b4641d8-57f0-4c34-a29c-fdbb64882030
In the above case the problem was with the Office version. Back in 2020 it was a planned feature being rolled out but it was implemented as far back as version 2011(13426.20332), while my version is 2108(14326.20852) Semi-Annual Enterprise Channel. In fact the problem is affecting all of our staff, so it leads me to believe that perhaps in the Enterprise Channel this button is simply missing altogether.
Any help would be greatly appreciated.
Regards,
Archi
Microsoft 365 and Office | Excel | For business | Windows
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.