Feb 08 2021 10:06 AM
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:
Expected Option:
Thanks,
Keerthana
Feb 08 2021 12:34 PM
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.
Feb 08 2021 12:36 PM
Thanks for your response!
Sep 26 2023 09:44 AM