Forum Discussion

TF_123's avatar
TF_123
New Member
4 years ago
Solved

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 Edit...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
BA_Pete
Super User
4 years ago

 

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's avatar
TF_123
New Member
4 years ago

Hi Pete, there is no Update button here. 🙁

 

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

     

    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's avatar
      TF123
      New Member
      4 years ago

      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......