SOLVED

Enable Data Model O365

%3CLINGO-SUB%20id%3D%22lingo-sub-1339586%22%20slang%3D%22en-US%22%3EEnable%20Data%20Model%20O365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339586%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20cannot%20enable%20data%20model%20in%20Excel%20O365%2C%20I%20don't%20have%20the%20options%20as%20outlined%20in%20this%20support%20article%20(%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b%3C%2FA%3E)%26nbsp%3B%3C%2FP%3E%3CP%3EI%20ma%20trying%20to%20display%20text%20in%20a%20pivot%20table%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1339586%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339587%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20Data%20Model%20O365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339587%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637868%22%20target%3D%22_blank%22%3E%40gemma1040%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339632%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20Data%20Model%20O365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637868%22%20target%3D%22_blank%22%3E%40gemma1040%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20is%20your%20Office365%20subscription%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339670%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20Data%20Model%20O365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339670%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20for%20Mac%26nbsp%3B%3C%2FP%3E%3CP%3EVersion%2016.36%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20what%20you%20mean%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339673%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20Data%20Model%20O365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339673%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637868%22%20target%3D%22_blank%22%3E%40gemma1040%3C%2FA%3E%26nbsp%3BFrom%20the%20screenshot%20it%20appears%20that%20you%20are%20on%20a%20Mac.%20If%20so%2C%20then%20you%20will%20not%20be%20able%20to%20use%20the%20features%20you%20are%20looking%20for.%20The%20are%20only%20available%20on%20Excel%20for%20Windows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339677%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20Data%20Model%20O365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339677%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Byes%20I%20am%20on%20a%20Mac%2C%20I%20assumed%20it%20was%20the%20same.%20Thanks%20for%20the%20advice!%3CBR%20%2F%3EIts%20a%20shame%20we%20cant%20use%20the%20same%20features%20as%20windows%20users%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339678%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20Data%20Model%20O365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339678%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637868%22%20target%3D%22_blank%22%3E%40gemma1040%3C%2FA%3E%26nbsp%3BEdited%20my%20previous%20post!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
Highlighted

@gemma1040 

What is your Office365 subscription?

Highlighted

Excel for Mac 

Version 16.36

 

Is that what you mean?

Highlighted
Best Response confirmed by gemma1040 (New 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!

Highlighted

@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  

Highlighted

@gemma1040 Edited my previous post!