Data Model damaged in all workbooks

lingerman

New Member
Joined
Jan 29, 2016
Messages
3
I use Office 2013, and often create pivot tables that require I check off the "Add this data to the Data Model" box when selecting the data range. I know that this can only be done in an excel workbook (and not a CSV, etc.) and have never had an issue building this table before. Suddenly, every time I try to add the data to the data model, I get an error that reads "We couldn't load the Data Model. This may be because the Data Model in this workbook is damaged." I've received this message on multiple, unrelated workbooks and cannot figure out what might have happened. Can anyone provide insight?

Many thanks in advance!
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
On Windows Vista and Windows 7
To resolve the issue, add the USER group and allow these permissions.


1. Open the Local Group Policy Editor: gpedit.msc
2. Navigate to: Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment
3. Locate Policy: Increase a process working set
4. Open tab: Local Security Setting
Is it set up to allow the USERS group?
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top