Online Refresh corrupting data model Excel Desktop app version

%3CLINGO-SUB%20id%3D%22lingo-sub-3514170%22%20slang%3D%22en-US%22%3EOnline%20Refresh%20corrupting%20data%20model%20Excel%20Desktop%20app%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3514170%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20noticed%20some%20issues%20over%20the%20last%204%20weeks%20with%20online%20refresh%20for%20Excel%20that%20appears%20to%20be%20corrupting%20the%20version%20I%20open%20in%20Excel%20Desktop%20app.%20I%20can%20also%20replicate%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20using%20a%20spreadsheet%2C%20with%26nbsp%3B%20only%20powerpivot%26nbsp%3B%20and%20a%20data%20model%20(no%20power%20query)%2C%20for%20over%2012%20months%20with%20my%20team%2C%20its%20accessible%20on%20sharepoint.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERecently%2C%20I%20have%20noticed%20that%20after%20on%20ok%20online%20refresh%20online%2C%20when%20i%20then%20open%20the%20file%20in%20the%20excel%20desktop%2C%20followed%20by%20another%20refresh%20%2C%20I%20get%20a%20crash%20to%20desktop.%20I%20have%20tried%20to%20fix%2C%20but%20the%20file%20is%20basically%20ruined.%20Everything%20i%20try%20results%20in%20crash%20to%20desktop%20inlcuding%20inspecting%26nbsp%3B%20document%20and%20running%20in%20safe%20mode%20makes%20no%20difference.%20It%20seems%20as%20though%26nbsp%3B%20the%20data%20model%20in%20the%20excel%20app%20is%20broken%20but%20it%20still%20works%20in%20online%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3514170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Hi

 

I have noticed some issues over the last 4 weeks with online refresh for Excel that appears to be corrupting the version I open in Excel Desktop app. I can also replicate it.

 

I have been using a spreadsheet, with  only powerpivot  and a data model (no power query), for over 12 months with my team, its accessible on sharepoint.  

 

Recently, I have noticed that after on ok online refresh online, when i then open the file in the excel desktop, followed by another refresh , I get a crash to desktop. I have tried to fix, but the file is basically ruined. Everything i try results in crash to desktop inlcuding inspecting  document and running in safe mode makes no difference. It seems as though  the data model in the excel app is broken but it still works in online


Any ideas?

 

Any ideas?

0 Replies