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.
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!
UY-SCUTI Great! Personally I prefer Parallels as it allows me to run both MacOs and Windows simultaneously and switch between them on demand. But it costs a bit of money, of course.