No "Relationships" option in Data section in Excel in MacBook Pro

%3CLINGO-SUB%20id%3D%22lingo-sub-2118091%22%20slang%3D%22en-US%22%3ENo%20%22Relationships%22%20option%20in%20Data%20section%20in%20Excel%20in%20MacBook%20Pro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118091%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20work%20with%20a%20pivot%20table.%20I%20created%202%20pivot%20tables%20and%20tried%20to%20find%20a%20%22relationship%22%20option%20in%20the%20data%20tab.%20But%20that's%20not%20available%20on%20my%20MacBook.%20Could%20you%20please%20help%20me%20with%20this%3F%3C%2FP%3E%3CP%3EMy%20Excel%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Keerthana_Devanand_0-1612807484303.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253390iA598BBD55F1A5CFC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Keerthana_Devanand_0-1612807484303.png%22%20alt%3D%22Keerthana_Devanand_0-1612807484303.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EExpected%20Option%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Keerthana_Devanand_1-1612807535259.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253391i45FE2CA3785B9CD6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Keerthana_Devanand_1-1612807535259.png%22%20alt%3D%22Keerthana_Devanand_1-1612807535259.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EKeerthana%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118353%22%20slang%3D%22en-US%22%3ERe%3A%20No%20%22Relationships%22%20option%20in%20Data%20section%20in%20Excel%20in%20MacBook%20Pro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118353%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20response!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118351%22%20slang%3D%22en-US%22%3ERe%3A%20No%20%22Relationships%22%20option%20in%20Data%20section%20in%20Excel%20in%20MacBook%20Pro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118351%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959740%22%20target%3D%22_blank%22%3E%40Keerthana_Devanand%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20data%20model%20is%20not%20supported%20on%20Excel%20for%20Mac.%20No%20data%20model%20-%20no%20relationships%20within%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20vote%20for%20that%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F19568977-add-powerpivot-to-mac-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAdd%20PowerPivot%20to%20Mac%20excel%20%E2%80%93%20Welcome%20to%20Excel%E2%80%99s%20Suggestion%20Box!%20(uservoice.com)%3C%2FA%3E%26nbsp%3B%2C%20so%20far%20you%20may%20install%20Windows%20on%20top%20of%20MacOS%20and%20work%20with%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I have to work with a pivot table. I created 2 pivot tables and tried to find a "relationship" option in the data tab. But that's not available on my MacBook. Could you please help me with this?

My Excel:

Keerthana_Devanand_0-1612807484303.png

Expected Option:

Keerthana_Devanand_1-1612807535259.png

 

 

Thanks,

Keerthana

2 Replies

@Keerthana_Devanand 

To my knowledge data model is not supported on Excel for Mac. No data model - no relationships within it.

 

You may vote for that here Add PowerPivot to Mac excel – Welcome to Excel’s Suggestion Box! (uservoice.com) , so far you may install Windows on top of MacOS and work with it.