Forum Discussion
Pivot source table changed to tabular format, doesnt work for Mac
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.
https://1drv.ms/x/s!Au88aXReRbBZg8RhWUBX3BIbC0rSgA?e=rqprfZ
Hmmm... what's not working? It looks tabular to me. And the pivot table is populated. What are you wanting to see that you're not?
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.
That's not supported in Excel for the Mac! That's why you can't click in the pt and drill down.
melankaya And that's also why I, also on a Mac, couldn't see the difficulty. Thanks, Riny.
