Forum Discussion
Excel 365 for Mac - Get & Transform/Power Query functionality
UY-SCUTI I went the opposite way. A long time Mac user, realising that Excel for Mac wasn't really living up to my needs. I had an MS365 Business subscription that allowed me to install the full Office package on up to 5 PC's and/or Macs, plus a bunch of mobile devices. I bought Parallels and W10 and happily run the full Excel version on a virtual Windows machine, on one of my Macs, a rather old MacBook Pro. Works good enough for me. If you have a newer Mac, it's going to run even better, I suspect. At the same time, running Excel on two more Macs and a Huwawei laptop (all under the same subscription), though with the limited functionality (as you recently discovered) on both Macs.
Thank you for thinking along, have not really thought of the option of installing Windows OS on the Macbook! Will definitely give that a try, any chance you know if my Office 365 family subscription will allow me to install a Windows version as well?
Also thanks for those roadmap links, as for Get & Transform (former Power Query) it does seem like there is some activity on this topic still, also seeing users regularly requesting updates on this.
Guy Hunkin, Would you be able to tell more?
UY-SCUTI I went the opposite way. A long time Mac user, realising that Excel for Mac wasn't really living up to my needs. I had an MS365 Business subscription that allowed me to install the full Office package on up to 5 PC's and/or Macs, plus a bunch of mobile devices. I bought Parallels and W10 and happily run the full Excel version on a virtual Windows machine, on one of my Macs, a rather old MacBook Pro. Works good enough for me. If you have a newer Mac, it's going to run even better, I suspect. At the same time, running Excel on two more Macs and a Huwawei laptop (all under the same subscription), though with the limited functionality (as you recently discovered) on both Macs.
- Guy Hunkin
Microsoft
I suggest you follow the announcements on the Excel blogs portal here. In addition, it's worth noting that this support article accurately reflects the currently supported Power Query features on Mac. Hope this helps.
Guy
- Excel Team
Guy Hunkin Not really my problem. I moved away from Excel for Mac as it just can't deliver what I need/want. I believe the biggest issue is that you don't have full Excel functionality on a Mac. Quite a few missing features. With regard to PQ, the options in the support article arn't really user friendly. Using complicated VBA code to create the simplest of queries is not something I will spend any time on. As said in my post, I run Excel for Windows on a virtual machine on a Mac and am totally happy with that.
Up to UY-SCUTI to decide what he wants.
Riny_van_Eekelen and SergeiBaklan Thank you for thinking along. I have now created a Windows 10 partition by using Bootcamp and that actually works perfect for me, starting up WindowsOS way faster than MacOS on the same Macbook/hardware - ROFL.
I have now created and merged several queries that pull data from Web putting the data in one table in a sheet, all done on WindowsOS as I am used to do.
It works perfectly fine to open this file on MacOS and refreshing all, as referred to by Guy Hunkin in the https://support.microsoft.com/en-gb/office/use-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5?ui=en-US&rs=en-GB&ad=GB. Still curious to see what is still being worked on so will keep following the Excel Blog portal.
Thanks again everyone for your suggestions, I appreciate it! Hope this also helps others that are having similar challenges. https://support.apple.com/en-us/HT201468 is very straight forward and only takes you a couple of minutes!
