Forum Discussion

melankaya's avatar
melankaya
Copper Contributor
Feb 02, 2024
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

  • mathetes's avatar
    mathetes
    Silver Contributor

    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.

    • melankaya's avatar
      melankaya
      Copper Contributor
      Ah I didn't realize that was alright! Thank you in advance, here you go.

      https://1drv.ms/x/s!Au88aXReRbBZg8RhWUBX3BIbC0rSgA?e=rqprfZ

      • mathetes's avatar
        mathetes
        Silver Contributor

        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?

Resources