Forum Discussion
Deleted
Oct 01, 2018Excel 2013 crashes when deleting one of the sheets or declare a file to be corrupted
Hi,
I have an Excel file made of numerous sheets linked together via formulas. When checking formulas using the Formula button on each sheet, no errors are detected.
When deleting one or the others of the sheets, sometimes and sometimes only Excel closes immediately.
More, sometimes and sometimes only, after a period of time, automatic save function is stopped, the file not being able to be saved too. Accepting to leave Excel to repair the file does not work, the file being declared corrupted.
Running Offcat is not very helpful as apart finding crashes have occured, no faults are detected (see attachment)
Is there a way to find somewhere a code or anything else allowing to retrieve the root of these issues?
1 Reply
- JKPieterseSilver ContributorSounds like the file is (close to becoming) corrupted. Unfortunately, finding the cause of the problem can be very hard. It sometimes helps to copy all worksheets to a brand new workbook. If you are using "format as table" tables, then you will have to do the copying one-by-one.