Jun 06 2022 06:33 AM
Jun 06 2022 06:33 AM
I got a file with a flat data table. I have built a dashboard based on pivot tables & charts. For some reason with the recent addition of some data fields, upon opening the XLSX it shows loading "Data Model".
I am trying to find the root cause, but am not able to open XLSX as it crashes continuously.
Protect view is able to open the sheet, but when i enable the edit mode, it just crashes.
Any solution to find the issue and fix the crash issue?
Jun 07 2022 02:49 AM
Jun 07 2022 04:27 AM
Yep, it doesn't even crashes, excel just turns off. I already tried disabling all ADD-ins, but still no results.
There was one thing which helped. I restored the excel file 3 days back and it worked fine, but here is the catch. I uploaded that file back to sharepoint and still the same problem happened. The only way for now to use it is Online version
As you said, I think it's a bug
Jul 14 2022 09:31 PM
I have this exact same problem. Any fix yet? I found I can upload the file to msteams download then open fine. But if I upload to msteam, then open and use the file then download, then try to open it force closes while loading the data model @eligaliokas any ideas anyone how to fix this? Or what could be wrong? This happened after adding additional columns to a table. And adding charts to a dashboard.
Jul 15 2022 12:33 AM
@GGGG670 I cannot figure out why it is crashing as there is no error, no message nor any indication of what is causing a crash. I am not stuck as it is working fine when I open it online as the file is placed in One Drive. I am trying to fix data models, pivot tables and whatnot to check what can fix the crash. So far no luck.
Jul 15 2022 03:03 AM
@eligaliokas Thanks for that. Maybe rebuilding the workbook from scratch? And transferring data (big sigh).
Jul 15 2022 03:08 AM
Sep 22 2022 10:50 AM
@athalekar I've been having this problem also and over the last few days have tried various remedies mentioned here an elsewhere, and tried different orders or ways of doing things. Here is what finally seems to work for me:
So, anyhow.....not sure if this works for everyone, but it was the only way I could successfully refresh my file after many crashes/closes and lots of trial and error.