5

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.

Improve this question
5
  • Tell a bit about the content(s) of the file. Try save it in CSV format (which basicly is text).
    – Hannu
    Commented Jul 22, 2014 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
    Commented Jul 22, 2014 at 19:00
  • Have you tried saving the file in Safe mode? (office.microsoft.com/en-us/excel-help/…)
    – Kryten
    Commented Jul 22, 2014 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
    Commented Jul 22, 2014 at 20:35
  • This worked! I copied each sheet over and everything worked fine, I guess the original file was corrupted.
    – user2625177
    Commented Jul 22, 2014 at 20:42

5 Answers 5

Reset to default
5

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.

Improve this answer
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
    Commented Mar 31, 2017 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.

Improve this answer
1
  • but also you loose formulas
    – Sam
    Commented May 3, 2017 at 9:09
0

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.

Improve this answer
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().

Improve this answer
0

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

Improve this answer
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
    Commented Nov 20, 2019 at 16:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .