Forum Discussion

Copper Contributor

Mar 17, 2021

Pivot table or relations button on MAC os excel

Hi. Can’t find the pivot table or relations button on my excel Mac office 365.

Riny_van_Eekelen

Platinum Contributor

Mar 17, 2021

Dswohl If it is this what you are looking for, that's Windows only. Not available on Excel for Mac.

Smit_Shah
Copper Contributor
May 13, 2022
Riny_van_Eekelen Riny_van_Eekelen in that case can you help how to do Relationships on Mac with Office 365? Thanks for your help in advance.
- Riny_van_Eekelen
  Platinum Contributor
  May 13, 2022
  Smit_Shah No such thing as "Relationships" in Excel for the Mac. That's a part of the Data Model (Power Pivot), which is only available in the PC versions of Excel.
Dswohl
Copper Contributor
Mar 17, 2021
Thanks for response. Pivot table function is also not available for macOS excel?
- Riny_van_Eekelen
  Platinum Contributor
  Mar 17, 2021
  Dswohl No, Pivot Tables are part of Excel for the Mac, (see picture), but from the translation of your question it seemed you were asking for "Relationships".
  - Dswohl
    Copper Contributor
    Mar 17, 2021
    Hi. Can’t find pivot table option on my Mac OS excel. Thanks. Refer to relations button your photo was correct. I can’t find this option on my macOS so i will try to use pivot table to do the 2 tables relations but can’t either find pivot table button. Thanks

Resources