Forum Discussion
marie365
Apr 26, 2020Copper Contributor
power query mac office
Hi all, I was under the impression that Power Query would be available for insider fast users of Excel...but...is it case ? I cannot import any xlsx data in my excel 16.37.. Can you help ? Marie
Riny_van_Eekelen
Apr 27, 2020Platinum Contributor
marie365 Power Query is NOT available on Excel for Mac, unfortunately. You can only refresh queries made on Excel for Windows.
On a Mac myself, running Excel for Windows virtually, using Parallels.
marie365
Apr 27, 2020Copper Contributor
Riny_van_Eekelenthanks for your confirmation.....hope they plan to upgrade soon !
Any idea how to combine files (xlsx fils) if I don't want to run Excel for Windows virtually ?
- Riny_van_EekelenApr 27, 2020Platinum Contributor
marie365 Define "combine files". It can be anything from copying content of one and stick it to the bottom of another to more complex lookups (X,V, Index, Match). You name it. what kind of "combining" do you need?
- marie365Apr 27, 2020Copper Contributor
Riny_van_EekelenI just need to copy content of one file and stick it to the bottom of another.
- Riny_van_EekelenApr 27, 2020Platinum Contributor
marie365 Then you don't need PQ. Anything I can help with?