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

Copper 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

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

@Sergei Baklan 

Thanks to you sergei im failing my computer science lab. :(

U dic