Manage Data Model doesn't work

Question

_{Sunday, July 16, 2017 3:43 AM}

Hi,

I have Microsoft Office 365 subscription and have been using Excel a lot. One of my favourite features is PowerPivot aka Data Model but for some reason when I click Manage Data Model - nothing happens.

I made sure my connections have been loaded to Data Model but I just can't get it to open? Anybody else experienced something like that?

All replies (1)

_{Monday, July 17, 2017 9:49 AM}

Hi,

Do you get any error messages when try to open Data Model?

Do this problem appear in all Excel files?

How about creating a blank workbook and click the Manage Data Model option?

If this problem is appeared in all Excel files, please try to do a repair of Office application:

https://support.office.com/en-us/article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b?ui=en-US&rs=en-US&ad=US

After repairing Office application please re-enable PowerPivot add-in and try to load data model again.

If this problem is only appeared in a particular file, please try to check if the data is damaged. Try to re-add the data.

Regards,
Emi Zhang
TechNet Community Support

Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact [email protected].