excel gets crashed

%3CLINGO-SUB%20id%3D%22lingo-sub-2313260%22%20slang%3D%22en-US%22%3Eexcel%20gets%20crashed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313260%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EMy%20excel%20keeps%20on%20crashing%20and%20after%20recovering%20only%20data%20remains%20and%20all%20the%20graphs%20which%20I%20have%20plotted%20are%20gone.%20It%20happens%20every%20time%20with%20me%20which%20is%20very%20annoying%20when%20I%20am%20dealing%20with%20many%20plots%20and%20graphs.%20Please%20help%20me.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2313260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313798%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20gets%20crashed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313798%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042469%22%20target%3D%22_blank%22%3E%40begumemte%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20want%20to%20restore%20your%20Excel%2C%20we%20need%20detailed%20information.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWithout%20detailed%20information%2C%20no%20concrete%20proposal%20for%20a%20solution%20is%20possible.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EPlease%20provide%20precise%2Fmore%20information%2C%20such%20as%20which%20version%20of%20Excel%2C%20which%20operating%20system.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHappened%20while%20you%20were%20working%20with%20Excel%3F%20...%20with%20which%20worksheets%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E...%20xls%2C%20xlsx%2C%20etc.%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWhat%20happened%20when%20opening%20the%20Excel%3F%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHappened%20in%20OneDrive%20or%20Hard%20Disk%3F...%20as%20you%20can%20see%2C%20many%20questions%20who%20want%20an%20answer.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335274%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20gets%20crashed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335274%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20using%202019%20professional%20plus%20version%20in%20windows%2010.%20Whenever%20I%20open%20an%20xlsx%20file%20after%20saving%20(which%20contains%20many%20data%2C%20charts%20and%20diagrams)%20it%20crashes.%20It%20happened%20both%20in%20onedrive%20and%20hard%20disk.%20I%20did%20a%20repair%20both%20offline%20and%20online%20and%20also%20reinstalled%20it%2C%20but%20the%20issue%20was%20not%20solved.%20Then%20I%20uninstalled%20that%20version%20and%20installed%202016%20professional%20plus%20version%20and%20now%20it%20is%20working%20fine.%20If%20the%20problem%20arises%20again%2C%20I%20will%20post%20it%20here.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello all,

My excel keeps on crashing and after recovering only data remains and all the graphs which I have plotted are gone. It happens every time with me which is very annoying when I am dealing with many plots and graphs. Please help me. Thank you.

8 Replies

@begumemte 

You want to restore your Excel, we need detailed information.

 

Without detailed information, no concrete proposal for a solution is possible. https://techcommunity.microsoft.com/t5/excel/welcome-to-your-excel-discussion-space/m-p/2204395

 

Please provide precise/more information, such as which version of Excel, which operating system.

Happened while you were working with Excel? ... with which worksheets? ... xls, xlsx, etc.?

What happened when opening the Excel?

Happened in OneDrive or Hard Disk?... as you can see, many questions who want an answer.

 

First of all, you could do a repair.

Repair an Office application

 

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE 

I was using 2019 professional plus version in windows 10. Whenever I open an xlsx file after saving (which contains many data, charts and diagrams) it crashes. It happened both in onedrive and hard disk. I did a repair both offline and online and also reinstalled it, but the issue was not solved. Then I uninstalled that version and installed 2016 professional plus version and now it is working fine. If the problem arises again, I will post it here.

Thank you for your assistance.

@begumemte 

Does the problem only happen with this file?

... even after the new installation?

Does the problem only happen in files with this extension?

 

If it's just this file, then follow these steps.

Check whether the file contains a virus.

Check whether the file is defective.

Change file extension from .xlsx to .xlsm or .xls or .xml

It would be best to send this file (if it is possible without sensitive data) to see exactly where the problem may be.

 

I would be happy to know if the problem persists or has been resolved by it.

 

Thanks for your patience and time.

 

Nikolino

No sir, it happens with all the files which contain graphs and plots. Right now I do not have any screenshots otherwise I could have shown the error. I will definitely try the other extensions you have mentioned. And after I have installed other version, the problem has been resolved. But if it happens again I will post the error and the file here. Thanks a ton for helping.
I once read in an internet article that sometimes the online version and the offline version can lead to problems if they are installed at the same time.
The last thing I would do is do an update in advance
Update Office with Microsoft Update
then I would delete the online version and use the offline to see whether the problem is repeated.
If so, then vice versa, delete offline and work online.

I know that this takes a lot of time and effort, but if I could give an even simpler solution, I would like to do it.
Well maybe one of the specialists here knows a simpler solution, away.

I would appreciate your feedback.

@NikolinoDE 

Even after changing the version of my Microsoft office, the problem raised again. My excel sheets got crushed again.

@NikolinoDE 

I am attaching a few screenshots of the error message so that you can have some idea of what is going on.

Capture.JPG

Capture1.JPG

Capture2.JPG

   

@begumemte 

As far as I can see, your file searches for content from other files without success. At the same time, Excel says that it cannot open this file because the file is defective or Excel itself may be defective.

 

The last thing I can do here is guess, although I am not that good at it.

Maybe the file extension has been renamed and excel cannot open it. Example it was an .xls file and was saved as xlsx. Should not actually bring any problems of the kind to the fore, but if diagrams and tables are in play, it is a possibility.

 

the second thing I would advise is to do a repair.

Repair an Office application

 

This is where my knowledge ends, I hope you get on with it

 

Thank you for your patience and time

 

Nikolino

I know I don't know anything (Socrates)