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%3CLINGO-SUB%20id%3D%22lingo-sub-2217578%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20or%20relations%20button%20on%20MAC%20os%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1000499%22%20target%3D%22_blank%22%3E%40Dswohl%3C%2FA%3E%26nbsp%3BIf%20it%20is%20this%20what%20you%20are%20looking%20for%2C%20that's%20Windows%20only.%20Not%20available%20on%20Excel%20for%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-03-17%20at%2017.14.44.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264877i9EC8A84575B50984%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-03-17%20at%2017.14.44.png%22%20alt%3D%22Screenshot%202021-03-17%20at%2017.14.44.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2217595%22%20slang%3D%22es-ES%22%3ERe%3A%20Pivot%20table%20or%20relations%20button%20on%20MAC%20os%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217595%22%20slang%3D%22es-ES%22%3EThanks%20for%20response.%20Pivot%20table%20function%20is%20also%20not%20available%20for%20macOS%20excel%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2217633%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20or%20relations%20button%20on%20MAC%20os%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217633%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1000499%22%20target%3D%22_blank%22%3E%40Dswohl%3C%2FA%3E%26nbsp%3BNo%2C%20Pivot%20Tables%20are%20part%20of%20Excel%20for%20the%20Mac%2C%20(see%20picture)%2C%20but%20from%20the%20translation%20of%20your%20question%20it%20seemed%20you%20were%20asking%20for%20%22Relationships%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-03-17%20at%2017.46.53.png%22%20style%3D%22width%3A%20185px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264884i777E8606B06D54B5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-03-17%20at%2017.46.53.png%22%20alt%3D%22Screenshot%202021-03-17%20at%2017.46.53.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2217638%22%20slang%3D%22es-ES%22%3ERe%3A%20Pivot%20table%20or%20relations%20button%20on%20MAC%20os%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217638%22%20slang%3D%22es-ES%22%3EHi.%20Can't%20find%20pivot%20table%20option%20on%20my%20Mac%20OS%20excel.%20Thanks.%20Refer%20to%20relations%20button%20your%20photo%20was%20correct.%20I%20can't%20find%20this%20option%20on%20my%20macOS%20so%20i%20will%20try%20to%20use%20pivot%20table%20to%20do%20the%202%20tables%20relations%20but%20can't%20either%20find%20pivot%20table%20button.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2217780%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20or%20relations%20button%20on%20MAC%20os%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217780%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1000499%22%20target%3D%22_blank%22%3E%40Dswohl%3C%2FA%3E%26nbsp%3BPlease%20share%20a%20screen%20shot%20of%20the%20Insert%20tab%20of%20your%20ribbon.%20It%20should%20have%20the%20buttons%20as%20shown%20in%20the%20earlier%20comment.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi. Can’t find the pivot table or relations button on my excel Mac office 365.
7 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.

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

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