04-26-2020 01:39 PM
09-30-2020 08:54 PM
@Tiboli I'm not sure we are talking about the same thing here. Unless I have missed a major recent update, "Get & Transform Data" (a.k.a. Power Query) is NOT available in Excel for the Mac to the same extent as it is on the PC versions. Not too long ago, MS introduced the possibility to refresh certain queries on a Mac, but the queries themselves can be created in Windows versions only.
If I'm mistaken, I would love to see some proof of your full use of PQ in Excel for the Mac. Having said that, it is of course possible to run the Windows version of Excel, virtually on a Mac. That's what I'm doing myself.