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

%3CLINGO-SUB%20id%3D%22lingo-sub-2211313%22%20slang%3D%22en-US%22%3Eis%20Microsoft%20Power%20Query%20for%20Excel%20available%20ad%20an%20add%20for%20my%20and%20my%20365%20subscription%20(mac)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2211313%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22chattext-body%22%3Ei%20have%20been%20an%20access%20user%20for%20years%3C%2FP%3E%3CDIV%20class%3D%22chat-footer%22%3E%3CSPAN%3Ei%20recently%20switched%20to%20a%20mac%20mini%20(with%20an%20M1%20chip)%20and%20running%20parallels%20to%20use%20access%20is%20not%20working%20%3D(%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22chat-footer%22%3E%3CSPAN%3Ei%20came%20across%20a%20video%20on%20how%20to%20merge%20data%20from%20multiple%20worksheets%20based%20on%20a%20matching%20key%20column%20in%20Excel%20without%20using%20VLOOKUP%20function%20and%20it%20gives%20instruction%20how%20to%20do%20it%20-%20with%20a%26nbsp%3BMicrosoft%20Power%20Query%20for%20Excel%20add%20on%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22chat-footer%22%3E%3CSPAN%3Eis%20Microsoft%20Power%20Query%20for%20Excel%20add%20on%20an%20option%20for%20my%20and%20my%20365%20subscription%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22chat-footer%22%3E%3CSPAN%3Ehow%20can%20i%20add%20that%20on%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22chat-footer%22%3E%3CSPAN%3Eand%20if%20not%20%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Ecan%20anyone%20help%20or%20suggest%20a%20way%20to%20combine%202%20sheets%2F%3C%2FSPAN%3Eworkbooks%3C%2FDIV%3E%3CDIV%20class%3D%22chat-footer%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22chat-footer%22%3Ethanks%20so%20much%20in%20advance%20for%20your%20help%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-big-eyes%22%20title%3D%22%3Agrinning_face_with_big_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FDIV%3E%3CDIV%20class%3D%22chat-footer%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2211313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

i have been an access user for years

5 Replies

@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.

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

@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. 

@Riny_van_Eekelen thanks, unfortunately parallels does not seem to be working on my new mac mini - from what i am told,  it is not working with the m1 chip

i am trying to find workaround/solution that does not involve microsoft access

 

@joe-office Okay. I'm not much into chips. You wrote "i am really looking to simply combine 2 spreadsheets".

 

How simple is it then? Since you considered PQ and don't want to use Access.