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.
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.
- Ah I didn't realize that was alright! Thank you in advance, here you go.
https://1drv.ms/x/s!Au88aXReRbBZg8RhWUBX3BIbC0rSgA?e=rqprfZHmmm... 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?
