What kinds of data or formulas will cause a sheet to crash?

%3CLINGO-SUB%20id%3D%22lingo-sub-3185815%22%20slang%3D%22en-US%22%3EWhat%20kinds%20of%20data%20or%20formulas%20will%20cause%20a%20sheet%20to%20crash%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3185815%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%20I%20have%20a%20working%20spreadsheet%20I%20use%20for%20my%20job%20that%20is%20shared%20in%20a%20dropbox.%26nbsp%3B%20Its%20a%20pretty%20simple%2C%20straightforward%20spreadsheet.%26nbsp%3B%20Its%20a%20list%20of%20our%20client's%20contact%20info%2C%20with%20a%20few%20extra%20features%20and%20multiple%20tabs.%26nbsp%3B%20Yesterday%2C%20the%20thing%20crashed%20and%20became%20corrupted.%26nbsp%3B%20I%20was%20able%20to%20reboot%20an%20old%20version%20with%20help%20from%20microsoft%20support%2C%20but%20she%20could%20not%20tell%20me%20what%20caused%20it%20to%20crash%20in%20the%20first%20place.%26nbsp%3B%20She%20said%20there%20were%20some%20types%20of%20data%20that%20couldn't%20be%20supported%20with%20a%20file%20shared%20online.%26nbsp%3B%20I%20was%20opening%20the%20sheet%20to%20a%20blank%20excel%20page%2C%20from%20both%20the%20online%20account%20(dropbox)%20and%20from%20my%20computer%20file%20explorer.%26nbsp%3B%20To%20be%20clear%2C%20I%20edit%20the%20file%20offline%20and%20save%20to%20our%20dropbox.%26nbsp%3B%20Some%20snippets%20from%20our%20conversation%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%22Emily%2C%20there%20are%20some%20data%20added%20which%20are%20not%20supported%20by%20Excel%20that%20is%20the%20reason%20it%20does%20not%20open%20online%20as%20well...%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EThere%20few%20features%20that%20are%20supported%20by%20certain%20applications%20and%20the%20data%20included%20in%20that%20document%20is%20not%20supported%20by%20Excel%20both%20offline%20and%20online...%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EI%20am%20not%20trained%20on%20data%20types%2C%20it%20is%20out%20of%20my%20support%20boundary%20so%20I%20would%20not%20be%20able%20to%20check%20for%20the%20data%20type%20information%20however%20we%20have%20our%20experts%20from%20Excel%20Community%20who%20would%20be%20able%20to%20assist%20you.%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EWe've%20been%20using%20this%20sheet%20in%20this%20way%20for%20a%20couple%20of%20years%20and%20I%20wasn't%20doing%20anything%20particularly%20out%20of%20the%20ordinary%20when%20it%20crashed%20and%20got%20corrupted.%26nbsp%3B%20Does%20anyone%20know%20what%20could%20have%20caused%20this%3F%26nbsp%3B%20and%20how%20to%20avoid%20it%20in%20the%20future%3F%26nbsp%3B%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EThanks!%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E-Emily%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3185815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello!  I have a working spreadsheet I use for my job that is shared in a dropbox.  Its a pretty simple, straightforward spreadsheet.  Its a list of our client's contact info, with a few extra features and multiple tabs.  Yesterday, the thing crashed and became corrupted.  I was able to reboot an old version with help from microsoft support, but she could not tell me what caused it to crash in the first place.  She said there were some types of data that couldn't be supported with a file shared online.  I was opening the sheet to a blank excel page, from both the online account (dropbox) and from my computer file explorer.  To be clear, I edit the file offline and save to our dropbox.  Some snippets from our conversation:

 

"Emily, there are some data added which are not supported by Excel that is the reason it does not open online as well...

 There few features that are supported by certain applications and the data included in that document is not supported by Excel both offline and online...
 I am not trained on data types, it is out of my support boundary so I would not be able to check for the data type information however we have our experts from Excel Community who would be able to assist you."
 
We've been using this sheet in this way for a couple of years and I wasn't doing anything particularly out of the ordinary when it crashed and got corrupted.  Does anyone know what could have caused this?  and how to avoid it in the future? 
 
Thanks!
-Emily
0 Replies