Excel for Mac - Power Pivots

[slstewart249]

I now use Excel for Mac instead of the Windows version where I regularly used Power Pivots. How can I link tables and create Pivots that pull data from multiple tables in Excel for Mac? What are the best add-on, work arounds for the limitations of Mac version for pivot tables, data analysis, etc.?

 

[vletm]

slstewart249
1) Excel for Mac - Power Pivots
... it's not possible combination!
https://discussions.apple.com/thread/7284979

2) could You make 'google' like mac pivot table
and You could compare if there are differences.

 

[Chihiro]

While PowerPivot isn't possible in MAC, there's new query tool that replaced old query tool for MAC (Excel 2016 and up).

https://www.microsoft.com/en-us/mic...ing-with-external-data-in-excel-2016-for-mac/

But if you want to take full advantage of Data modeling, M and DAX. I'd recommend using PowerBI Desktop (and Pro subscription to PowerBI Service). While subscription isn't required, it would greatly enhance reporting capability and availability of reports published.