4

The instant I try saving a particular excel document excel will crash.

How do I solve this problem, I've tried saving as different excel formats but I got the same result, except for when I saved it as a text file which worked.

This is in excel 2013 I've tried repairing but I haven't tried reinstalling because it only does this for a specific file.

NOTE: When I open excel again in the autorecover pane the name of the file shows up with the word "repaired" in red.

5
  • Tell a bit about the content(s) of the file. Try save it in CSV format (which basicly is text). – Hannu Jul 22 '14 at 18:55
  • I stopped using it. And moved to Gnu/Linux. It is not perfect, but is much more reliable, and easier to use. – ctrl-alt-delor Jul 22 '14 at 19:00
  • Have you tried saving the file in Safe mode? (office.microsoft.com/en-us/excel-help/…) – Kryten Jul 22 '14 at 19:15
  • 4
    Create a blank new excel document File->New and copy all of your recovered/repaired content to the new file and try to save with this newly created document. This may fix. – Ĭsααc tիε βöss Jul 22 '14 at 20:35
  • This worked! I copied each sheet over and everything worked fine, I guess the original file was corrupted. – user2625177 Jul 22 '14 at 20:42
4

The new '.xlsb' or binary format tends to be much more stable, and can cut the on-disk file size by ~80% in many cases.

I've seen one or two larger files die inexplicably like yours did after years operating as a '.xls', but if you re-save them as an xlsb then this no longer appears to happen.

Oddly, if you save from the newly stable .xlsb back into the .xls, most files continue to crash on-save, which really does suggest to me that .xls just isn't able to handle the save operation on files that are more complex or unwieldy, but not necessarily corrupt.

1
  • 1
    xlsb files are not only smaller, they're much faster to read because with the normal xlsx format you have to convert from xml text to binary whereas with xlsb you already have binary values available – phuclv Mar 31 '17 at 12:04
1

This thread was posted long ago, but I thought I'd share my experience anyway.

Had the same problem and eventually traced it to one of the worksheets that I copied from another Excel file which had external links in it. I deleted that worksheet and copied all the data (as values, to remove the links) instead of copying the worksheet itself.

Works fine now. Hope this helps.

1
  • but also you loose formulas – Sam May 3 '17 at 9:09
0

We had a XLSM Excel 2013 workbook that was crashing on save, but only for some users. The problem was traced to a button that had been assigned the macro Workbook_Open() (from the Workbook macros). This seems to corrupt the button. To fix the problem we created a specific macro for the button that calls Workbook_Open(), then we deleted the button and re-created it with the new macro assigned to it in place of Workbook_Open().

0

I had issues as well, but it was saving as a Macro-enabled file. I changed to normal and all is working fine.

1
  • 3
    Can you go into a little more detail on how you "changed to norrmal"? Please see How to Answer and take our tour. – Burgi Nov 20 '19 at 16:34
-1

You can try opening the file in LibreOffice or OpenOffice, and then resaving it.

Both of those office suites are completely free of charge.

Sometimes programs in those suites can open files that cause problems in other office tools.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.