SOLVED

Enable Data Model O365

Copper Contributor

Hi, I cannot enable data model in Excel O365, I don't have the options as outlined in this support article (https://support.office.com/en-us/article/create-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75db...

I ma trying to display text in a pivot table

 

thanks 

6 Replies

@gemma1040 

What is your Office365 subscription?

Excel for Mac 

Version 16.36

 

Is that what you mean?

best response confirmed by gemma1040 (Copper Contributor)
Solution

@gemma1040 From the screenshot it appears that you are on a Mac. If so, then you will not be able to use the features you are looking for. The are only available on Excel for Windows.

 

Edit: You latest post showed up after I sent mine. Clear then!

 

On a Mac myself and running Excel for Windows, virtually with the help of Parallels. Works perfect!

@Riny_van_Eekelen yes I am on a Mac, I assumed it was the same. Thanks for the advice!
Its a shame we cant use the same features as windows users :( 

@gemma1040 Edited my previous post!

1 best response

Accepted Solutions
best response confirmed by gemma1040 (Copper Contributor)
Solution

@gemma1040 From the screenshot it appears that you are on a Mac. If so, then you will not be able to use the features you are looking for. The are only available on Excel for Windows.

 

Edit: You latest post showed up after I sent mine. Clear then!

 

On a Mac myself and running Excel for Windows, virtually with the help of Parallels. Works perfect!

View solution in original post