Forum Discussion

joe-office's avatar
joe-office
Copper Contributor
Mar 15, 2021

is Microsoft Power Query for Excel available ad an add for my and my 365 subscription (mac)

i have been an access user for years

i recently switched to a mac mini (with an M1 chip) and running parallels to use access is not working =(
i came across a video on how to merge data from multiple worksheets based on a matching key column in Excel without using VLOOKUP function and it gives instruction how to do it - with a Microsoft Power Query for Excel add on
is Microsoft Power Query for Excel add on an option for my and my 365 subscription?
how can i add that on
and if not , can anyone help or suggest a way to combine 2 sheets/workbooks
 
thanks so much in advance for your help 😃
 
Excel on Mac
Formulas and Functions
office 365

5 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 15, 2021

    joe-office You say you have Parallels. I run a virtual Windows machine (W10) on my Mac via Parallels. On it, I run the Excel for Windows version with full Power Query functionality. Power Query on Excel for Mac has rather limited functionality. You can't create or edit queries, but you can refresh certain queries that were created on a PC.

    • joe-office's avatar
      joe-office
      Copper Contributor
      Mar 15, 2021
      thanks for the reply.
      parallels is not installed on my new machine.
      i am looking for a NON parallels solution!
      i am really looking to simply combine 2 spreadsheets. there has to be a more efficient way!

      how do i install the Power Query on Excel for Mac ?
      i'd love to check it out
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Mar 15, 2021

        joe-office You can not run Power Query on Excel for Mac. You need to instal Excel for Windows on a virtual machine (Parallels, VMware or Bootcamp) if you want full functionality. 

Resources