Forum Discussion
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...
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?