Forum Discussion
Power Query et Power Pivot avec Excel en achat définitif
- Feb 19, 2021
Aurelien1745 You tagged your question with "Excel on Mac". Power Query and Power Pivot are NOT available on that platform. Some limited PQ functions are available, but you can not create or edit queries in Excel for the Mac.
Aurelien1745 You tagged your question with "Excel on Mac". Power Query and Power Pivot are NOT available on that platform. Some limited PQ functions are available, but you can not create or edit queries in Excel for the Mac.
Riny_van_Eekelen thank you for your answer.
If I understand Power functionalities are not avalable in Excel for Mac, isn’t it ?
If I would like to use these I had to use Excel for Windows ?
And what about Excel online ? In my browser ?
Aurélien
- Riny_van_EekelenFeb 21, 2021Platinum Contributor
Aurelien1745 Nope! You'll need a desktop Excel version for Windows. But, you can run Windows on a Mac using Bootcamp (starts-up your Mac with either MacOs or Windows) or products like VMWare or Parallels (these allow you to swap between both systems without restarting).
I'm using the last option on a fairly old MacBook Pro (late 2012). It's a bit slow if you handle very large data sets, but still acceptable for me.
- Aurelien1745Feb 21, 2021Copper Contributor
Riny_van_Eekelen alright I understand. so i can use a mac and use a virtual machine to emulate windows. what is the configuration of your macbook pro please?
- Riny_van_EekelenFeb 21, 2021Platinum Contributor
Here you have the specs: