Forum Discussion

UY-SCUTI's avatar
UY-SCUTI
Copper Contributor
Feb 13, 2021
Solved

Excel 365 for Mac - Get & Transform/Power Query functionality

    Hi Dears,   Recently switched over from Windows to MacOS, not knowing the versions of Excel 365 for both the OSes are not the same. More or less immediately ran into issues when trying to fin...
Excel on Mac
power bi
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 13, 2021

    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.

Matt_Costello750's avatar
Matt_Costello750
Copper Contributor
Nov 14, 2022

Riny_van_Eekelen 

I have Excel 16.68 (22110801) on the Insider program with an Office 365 Business Standard Subscription on a MacBook Pro with an Apple M1 Pro chip.

In the Power Query button the Launch Editor option isn't available. This is very frustrating as everything I read says it should be. Please help, I want to use PQ.

 

Matt

Gal_Zivoni's avatar
Gal_Zivoni
Icon for Microsoft rankMicrosoft
Nov 14, 2022

Matt_Costello750 

 

The Power Query Editor in Excel for Mac is available to Insiders Beta Channel and to Current Channel Preview. The following steps may help with this situation:

 

1. Close Excel by right-clicking on the Excel app on the Dock and pressing "Quit"
2. Sign out from your Office account
3. Sign in back to your Office account
4. Re-open Excel

 

Gal

Excel Team

Resources