Forum Discussion
Power Query Compatibility Warning and missing in Excel 2016
I have installed Microsoft Office Professional Plus 2016 (Version: 16.0.4266.1001), but it cannot open Power Query and shown below image. It just open as Query Editor but not Power Editor. Query Editor cannot provide some function, so I need to have a Power Query. Thank you.
There are some action I have tried:
1. I have re-installed Microsoft Office
2. I have downloaded Power Query add-in from Microsoft, but the installer shows the plug-in already installed. The reason should be Power Query add-in embbed on Microsoft Office and I have no idea to update / remove that plugin independently
3. I checked Excel Option > Excel Add-ins / COM Add-ins / Disabled items, no more findings
Hi TF_123 ,
My Microsoft Excel version is Excel 2016:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 Replies
Thanks for your reply. But it did not appear on my Excel.
Hm, ok.
Mine's Version 2206 Build 16.0.15330.20216 64-bit.
Are you able to find and dowload a more advanced version? If you've downloaded your Excel from the native O365 prompt, then your current licence may not allow you the most up-to-date or advanced version.
Pete
Hi TF_123 ,
My Microsoft Excel version is Excel 2016:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I developed the file and it works perfectly fine on my System, But all my user are unable to run it that smoothly and Face an error due to compatibility issues, I think it is not a best practice to ask all my user to update the Version by reinstalling.
Option 1: I can develop the complete code in VBA but I won't get the facilities of Power Query and easy calculations.
What do you guys suggest to me as the best option for me at this stage?
i have same issue, dunno how to solve it
