Power Query Compatibility Warning and missing in Excel 2016

[TF_123]

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

[Sara186]

i have same issue, dunno how to solve it 

[JigneshMore]

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?

[v-eqin-msft · Accepted solution]

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.

[BA_Pete]

Hi @TF_123 ,

Silly question, I'm sure, but have you tried opening PQ using the Get Data button on the Data tab?

Pete

[TF_123]

 Thanks for your reply. But it did not appear on my Excel.

[BA_Pete]

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

[TF_123]

Hi Pete, there is no Update button here. 🙁

[BA_Pete]

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.

Pete

[TF123]

Dear Pete,

Thanks for your comment, but the key is professional plus, the other PC have this feature, but for new installed one, it did not......