Forum Discussion

athalekar's avatar
athalekar
Copper Contributor
Jun 06, 2022

Excel is crashing during showing "Loading Data model" on starting

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 "Dat...
Excel
office 365
eligaliokas's avatar
eligaliokas
Copper Contributor
Did you found solution ?
athalekar's avatar
athalekar
Copper Contributor
Jun 07, 2022
Nope. It's working fine with online version. So that's my workaround. It seems MS Excel 365 has bug which is crashing the desktop application.
  • eligaliokas's avatar
    eligaliokas
    Copper Contributor
    Jun 07, 2022

    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
    athalekar 

    • GGGG670's avatar
      GGGG670
      Copper Contributor
      Jul 15, 2022

      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.

      • athalekar's avatar
        athalekar
        Copper Contributor
        Jul 15, 2022

        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. 

Resources