Forum Discussion
Solved
Pivot source table changed to tabular format, doesnt work for Mac
The source table was not in a tabular format before. Please help so I can use it on my mac as well.
melankaya You used Power Pivot / Data Model on your PC to create the pivot table. That's not supported in Excel for the Mac! That's why you can't click in the pt and drill down.
mathetes it works on my pc which is where I populated it, but on the mac when im on the pivot it doesnt recognize its a pivot. Just a table of numbers. When I click on it the pivot table tools do not appear.
melankaya You used Power Pivot / Data Model on your PC to create the pivot table. That's not supported in Excel for the Mac! That's why you can't click in the pt and drill down.
