Fix- Issue with data model preventing Excel from opening workbook

While accessing a worksheet with an Excel of the previous version you may experience an encounter – ‘We couldn’t load the data model‘. This error basically occurs if you use outdated Excel ( like- MS Excel 2013 or older) to open new datasheets which are prepared which contain newer data models. Follow these fixes to solve the issue.

Workarounds-

1. Disable your antivirus while using the MS Excel. Sometimes AV settings interfere with the Excel process.

2. Save your work first and then close Excel. Sometimes force-closure of an excel document may close this kind of issue.

 



Fix 1 – Use newer Excel versions

The simplest fix for this problem is to use a newer version of Excel. There is a good no of alternatives to Excel that are available on the market.

 

 

Fix 2 – Modify Local Group Policy settings-

1. At first, you need to type “Local Group Policy” in the search box.

2. A simple click on the “Edit Group Policy” in the search result and you will see that the Local Group Policy Editor has appeared on your screen.

 

Local Security Policy Serach

 

3. After the Editor appears on your screen, expand the left-side in this way-

Computer Configuration/Windows Settings/Security Settings/Local Policies/User Rights Assignment

 

User Rights Assignment Exp

 

4. On the right-hand side of the Policy section, scroll down to find “Increase a process working set“.

5. Double click on it.

 

Increase A Process Working Set

 

6. In Increase a process working set policy screen, click on the “Add User or Group…“.

 

Add User Or Group

 

7. In the Enter the object names to select window, enter “Users“.

8. Then, click on “Check Names“.

9. Click on “OK“.

 

Users Check Names



 

10. After that, click on “Apply“.

10. Finally, click on “OK“.

 

Apply Ok

 

Once you have done that, close the Local Group Policy Editor screen.
Try accessing the excel document again.