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.

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
  - Steve_K_Excel
    Iron Contributor
    Mar 17, 2021
    Dswohl Please share a screen shot of the Insert tab of your ribbon. It should have the buttons as shown in the earlier comment.

Resources