Users face several issues on various devices, especially while trying to open MS Excel files. One of such error is “Data model restricting MS Excel Files to launch Workbook.” This error usually occurs while using earlier editions of MS Excel. Some users face issues “We couldn’t load the data model” even on Windows 10 when they try to open Excel file on outdated or earlier versions. It’s one of the most occurring annoying errors even on Windows 10.
This issue arises even when trying to launch PowerPivot on Windows 10 OS with Office suite 365. If you are also encountering such issues, then this blog is for you.
If you wish to get rid of this issue, then there are three simple methods to follow. It is recommended to pursue every point of a particular section to avoid data loss or file crash.
Removing the Issue by Changing the Office Suite
◾One of the reliable office suites for this solution is WPS Office as it’s one of the most used premium edition. It offers a browser like all in one mode for the compatibility and productivity ease.
◾This particular suite provides three prominent tools: WPS Presentation, WPS Spreadsheet, WPS Writer and these three are completely compatible for Office programs such as Excel, Powerpoint and MS Word accordingly. It supports the full accessibility of PDF files.
◾Using a single account profile, you can quickly get all the premium features of the complete Office suite with the comfort of your time and place. If you want to save your document, there is a cloud feature that helps you to save your docs with ease and protection. Then, you don’t need to save anything locally.
The basic suite is completely free for the users, but for the premium features, you should pay the respective amount.
Fixing Data Model Issue through Changing Local Group Policy Settings
◾Tap two keys: “Win + R” altogether to launch Run Dialogue box.
◾After that, you have to input “gpedit.msc” into the search bar followed by the Enter key. Alternatively, you may press the OK tab to proceed.
◾After a while, the Local Group Policy Editor will expand on your screen, and you have to move to the path written below:
“Computer_Configuration_Windows Settings\Security_Settings\Local_Policies\User_Rights_Assignment.”
◾Then, search for the policy option related to increasing of the process working setup and then double-click on it.
◾Sometime later, a listing will prompt up on the screen, and you have to search the Users Group. Once located it, check that the Users group isn’t available in the list, tap the button “Add Group or User.”
◾Now, type the “Users” into the bar “Enter the object names to select enters” and then tap the “Check Names” followed by the Enter key there.
◾After some time, the Users group will be added successfully. Hit the Apply tab followed by the Enter key to Save modifications that you have made.
Disabling SQL Server Analysis Services (SAS)
To troubleshoot the error “We couldn’t load the data model” on your device, there is another method of SQL SAS (Tabular) services. You need to turn off this feature on your device.
Sometimes, deleting Analysis Services 2012 also removes various glitches. In order to disable SQL Server Analysis Services (Tabular) services on your device, pursue these guidelines:
◾First and foremost, launch Control Panel and perform a double click on the option Remove or Add Programs.
◾Go to the section related to recently installed apps or programs, then choose “MS SQL Server” and then hit the Change tab.
◾Navigate to the page “Component Selection” and locate the section “SQL Server instances. Then, choose the particular Instance that consists of the Analysis Services instance that you desire to delete.
◾Go to the page “Feature Maintenance” and choose the option “Analysis Services” in order to open the installation wizard of Microsoft SQL Server.
◾Now, move to the page for Removing and Changing Instance, hit the Remove Microsoft SQL Server option there.
◾Tap on Next and pursue all the on-screen instructions to finish the ongoing process to fix the issue.
◾Finally, reboot the device to accept the modifications.
Source :- https://myblog-search.uk.com/how-to-fix-an-issue-with-the-data-model-is-preventing-microsoft-excel-from-launching-workbook/