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

%3CLINGO-SUB%20id%3D%22lingo-sub-3471640%22%20slang%3D%22en-US%22%3EExcel%20is%20crashing%20during%20showing%20%22Loading%20Data%20model%22%20on%20starting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3471640%22%20slang%3D%22en-US%22%3E%3CP%3EI%20got%20a%20file%20with%20a%20flat%20data%20table.%20I%20have%20built%20a%20dashboard%20based%20on%20pivot%20tables%20%26amp%3B%20charts.%20For%20some%20reason%20with%20the%20recent%20addition%20of%20some%20data%20fields%2C%20upon%20opening%20the%20XLSX%20it%20shows%20loading%20%22Data%20Model%22.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20the%20root%20cause%2C%20but%20am%20not%20able%20to%20open%20XLSX%20as%20it%20crashes%20continuously.%26nbsp%3B%3C%2FP%3E%3CP%3EProtect%20view%20is%20able%20to%20open%20the%20sheet%2C%20but%20when%20i%20enable%20the%20edit%20mode%2C%20it%20just%20crashes.%3C%2FP%3E%3CP%3EAny%20solution%20to%20find%20the%20issue%20and%20fix%20the%20crash%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3471640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3475863%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20is%20crashing%20during%20showing%20%22Loading%20Data%20model%22%20on%20starting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3475863%22%20slang%3D%22en-US%22%3EDid%20you%20found%20solution%20%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3475887%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20is%20crashing%20during%20showing%20%22Loading%20Data%20model%22%20on%20starting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3475887%22%20slang%3D%22en-US%22%3ENope.%20It's%20working%20fine%20with%20online%20version.%20So%20that's%20my%20workaround.%20It%20seems%20MS%20Excel%20365%20has%20bug%20which%20is%20crashing%20the%20desktop%20application.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3476312%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20is%20crashing%20during%20showing%20%22Loading%20Data%20model%22%20on%20starting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3476312%22%20slang%3D%22en-US%22%3E%3CP%3EYep%2C%20it%20doesn't%20even%20crashes%2C%20excel%20just%20turns%20off.%20I%20already%20tried%20disabling%20all%20ADD-ins%2C%20but%20still%20no%20results.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20was%20one%20thing%20which%20helped.%20I%20restored%20the%20excel%20file%203%20days%20back%20and%20it%20worked%20fine%2C%20but%20here%20is%20the%20catch.%20I%20uploaded%20that%20file%20back%20to%20sharepoint%20and%20still%20the%20same%20problem%20happened.%20The%20only%20way%20for%20now%20to%20use%20it%20is%20Online%20version%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20you%20said%2C%20I%20think%20it's%20a%20bug%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1398786%22%20target%3D%22_blank%22%3E%40athalekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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?

3 Replies
Did you found solution ?
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.

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