Pivot table or relations button on MAC os excel

Question

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

riny_van_eekelen · Answer

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

dswohl · Answer

Thanks for response. Pivot table function is also not available for macOS excel?

riny_van_eekelen · Answer

Dswohl&nbsp;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 · Answer

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 · Answer

Dswohl&nbsp;Please share a screen shot of the Insert tab of your ribbon. It should have the buttons as shown in the earlier comment.

Forum Discussion

Pivot table or relations button on MAC os excel

7 Replies

Resources