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.
7 Replies
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=rqprfZ
