Excel 2010 File Corruption

[Domski]

Hi,

Has anyone else noticed that large Excel files seem to corrupt more often in Excel 2010?

I hardly ever used to have a problem with file corruption in 2003 but it seems much more regular (and annoying) now.

Dom

 

[Domski]

This is starting to do my head in!!! Another day's work wasted as the file I was working on yesterday has corrupted again and Excel can't recover the data.

It's a big file, 61mb, with a few reports from SAP 300,000 records plus and a bunch of lookups and calculations.

Saved it regularly throughout the day and closed/re=opened. This afternoon I go to work on it again and it's buggered.

Losing the will to live.

Dom

 

[Derek Brown]

I occasionally have workbooks (xlsx/xlsm) that fail to save over the Network, getting a "File not saved" message, so I make sure that I 'save' first before closing the workbook instead of relying on the "Do you want to save.." option if I just close the workbook. For large files (40+ Mb), I frequently save, close, take a backup copy and the re-open the workbook.
You did not say which file type you are using but, if it is not .xlsb, you may want to consider trying that (note that some people appear to have encountered some limitations with that format). In the early days of Excel 2007 I found them to be smaller in size, faster (I believe) and less likely to become corrupt.

 

[NdNoviceHlp]

Turn off your document recovery "feature" and just for funzies trial zipping and unzipping your file. HTH. Dave

 

[Domski]

I was using xlsx so I've changed to xlsb in case it's the file compression causing the problems.

Dom