SOLVED

Pivot source table changed to tabular format, doesnt work for Mac

Copper Contributor

The source table was not in a tabular format before. Please help so I can use it on my mac as well. 

7 Replies

@melankaya 

 

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

@melankaya 

 

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. 

best response confirmed by mathetes (Silver Contributor)
Solution

@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.

Screenshot 2024-02-03 at 08.08.39.png

@Riny_van_Eekelen 

 

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. 

1 best response

Accepted Solutions
best response confirmed by mathetes (Silver Contributor)
Solution

@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.

Screenshot 2024-02-03 at 08.08.39.png

View solution in original post