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.
Were you intending to attach a copy of the spreadsheet? In the absence of that, there's not much anybody can do to help.
You probably are not able to post a copy of the spreadsheet here, but you can put it on OneDrive or GoogleDrive with a link pasted here that grants access. Just don't include any confidential information in any file you post.
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.