3 posts • Page 1 of 1
I'm getting a Compatibility Warning when opening a workbook with queries made at work. It says "the queries were authored with a newer version of Power Query and might not work in your current version." The funny thing is, both my work and home version of Excel are 2016. Another strange thing i noticed about my home version is ever since I reinstalled and starting having these issues, I don't have the ability to create a conditional column in PQ; the option is completely missing. Any clues?
- No Conditional Column Option.png (7.45 KiB) Viewed 194 times
- Compatibility Warning.png (8.01 KiB) Viewed 194 times
It seems to me (from your screenshot) that you do not have the latest version of PQ? For the past few months, PQ has also had "Column From Example" and "Invoke Custom Function". I do not see these in your screenshot? Maybe try running Windows/Office Updates? This will also probably resolve your compatibility issues.
Who is online
Users browsing this forum: No registered users and 1 guest