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
Jun 07, 2022
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.

Resources