Forum Discussion

Deleted's avatar
Deleted
Oct 01, 2018

Excel 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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Sounds 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.