Excel online broke document

%3CLINGO-SUB%20id%3D%22lingo-sub-2190102%22%20slang%3D%22en-US%22%3EExcel%20online%20broke%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190102%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3Ewe%20meet%20a%20case%20when%20Excel%20Online%20brokes%20the%20document%20(the%20document%20is%20saved%20on%20Sharepoint).%3C%2FP%3E%3CP%3EWe%20do%20work%20in%20parallel%2C%20with%20our%20own%20add-on%20helping%20us%20to%20control%20the%20behavior%20(it%20changes%20Excel%20Protection%20for%20cells%20and%20some%20graphical%20properties).%3C%2FP%3E%3CP%3EThe%20situation%20looks%20bad%3A%3C%2FP%3E%3CP%3Ewe%20found%20that%20the%20document%20is%20broken%20after%206%20hours%20from%20the%20event%20-%20we%20have%20a%20history%20with%20about%2012%20autosave%20document%20revisions.%20The%20user%20working%20on%20the%20document%20didn%60t%20notice%20that%20it%20is%20broken%2C%20but%20other%20people%20were%20not%20able%20to%20open%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20try%20to%20recover%20it%20and%20see%2C%20that%3C%2FP%3E%3CP%3E1.%20it%20is%20possible%20only%20if%20I%20have%20access%20to%20Sharepoint.%20People%20logged%20with%20simply%20Email%20can%60t%20do%20it%20because%20they%20can%60t%20open%20the%20document%20with%20URL%20(Excel%20reports%20about%20the%20problem)%3C%2FP%3E%3CP%3E2.%20even%20with%20local%20Excel%20version%3A%20Excel%20reports%20about%20recovery%20done%2C%20but%20when%20I%20try%20to%20open%20the%20recovered%20version%20it%20is%20still%20reported%20as%20broken%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20we%20can%20control%20such%20a%20state%20and%20how%26nbsp%3Bhow%20can%20we%20be%20warned%20about%20the%20problem%20before%20it%20is%20too%20late%3F%20what%20could%20be%20the%20cause%20of%20the%20document%20failure%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20and%20Regards%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAndrew%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2190102%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello,

we meet a case when Excel Online brokes the document (the document is saved on Sharepoint).

We do work in parallel, with our own add-on helping us to control the behavior (it changes Excel Protection for cells and some graphical properties).

The situation looks bad:

we found that the document is broken after 6 hours from the event - we have a history with about 12 autosave document revisions. The user working on the document didn`t notice that it is broken, but other people were not able to open it. 

I did try to recover it and see, that

1. it is possible only if I have access to Sharepoint. People logged with simply Email can`t do it because they can`t open the document with URL (Excel reports about the problem)

2. even with local Excel version: Excel reports about recovery done, but when I try to open the recovered version it is still reported as broken

 

How we can control such a state and how how can we be warned about the problem before it is too late? what could be the cause of the document failure?

 

Thanks and Regards,

Andrew

0 Replies