Pivot table or relations button on MAC os excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2217507%22%20slang%3D%22es-ES%22%3EPivot%20table%20or%20relations%20button%20on%20MAC%20os%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217507%22%20slang%3D%22es-ES%22%3EHi.%20Can't%20find%20the%20pivot%20table%20or%20relations%20button%20on%20my%20excel%20Mac%20office%20365.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2217507%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Hi. Can’t find the pivot table or relations button on my excel Mac office 365.
5 Replies

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

 

Screenshot 2021-03-17 at 17.14.44.png

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

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

Screenshot 2021-03-17 at 17.46.53.png

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

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