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
Solved! Go to Solution.
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?
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.
Sorry, I don't know what to suggest.
If your current Office licence doesn't allow you a version that has all the features you need, then I guess you'll need to upgrade your licence. That's pretty much how systems licensing works: Want more features? Pay more money.
Thanks for your comment, but the key is professional plus, the other PC have this feature, but for new installed one, it did not......
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!