Excel\Power Pivot - Data model preventing from opening workbook

Anything related to PowerPivot and DAX Formuale
adman
Posts: 1
Joined: Thu Jul 18, 2019 3:49 am

Excel\Power Pivot - Data model preventing from opening workbook

Postby adman » Thu Jul 18, 2019 4:27 am

Getting the error in Excel that "An issue with the Data Model is preventing Microsoft Excel from opening this workbook". We have a new antivirus client and when the AV service is running we either get that error or experience slowness on the computer and with Excel. Excel is excluded in the AV settings but the error only goes away once antivirus is disabled.

guyrold
Posts: 2
Joined: Mon Jul 22, 2019 8:00 pm

Re: Excel\Power Pivot - Data model preventing from opening workbook

Postby guyrold » Mon Jul 22, 2019 8:46 pm

Hello!

You should update your excel version.

I experienced the same issue. I didn't know that it was the antivirus that was hurting excel!
Early Excel 2016 versions did sometimes spoil my workbook datamodel!

To avoid that, always "save" your file before clicking the "close button". Don't click save when excel suggests you to save it when you're closing the workbook! But if you're up to date you won't experience that bug.

Cheers!

mmanager
Posts: 1
Joined: Wed Aug 14, 2019 9:47 pm

Re: Excel\Power Pivot - Data model preventing from opening workbook

Postby mmanager » Wed Aug 14, 2019 10:02 pm

Hi!
Can you please write here which antivirus has this issue? I collect information for my site https://antivirus-review.com/ and it can be a good addition for antivirus review (people often search on the web about solutions of similar problems)
If you want to write it on this site by your name, please, contact me!


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 6 guests