Excel File corrupt and data lost

[vijayendra.shukla]

Hi All,

I have a shared excel sheet which got corrupt due to some unknown reasons. I replaced the sheet with old version and it worked fine for the team mates to update the data into it. But after some time it again got corrupted and most of the data got lost including the formatting and everything. This is the second time I faced this issue. Any idea why this is happing???

Refer to the below given error messages that i got.

1. I am getting this error message when I opened the shared workbook.

"The document is corrupt and cannot be opened. To try and repair it, use the Open and Repair command in the Open dialog (File Menu) and select Extract Data when prompted."
There is Ok button for this error message

2. When I clicked ok I got the below given error message.

"Error were detected in '<FILE Name>' but Microsoft office Excel was able to open the file by making the repairs listed below. Save the file to make this repairs permanent.

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

Then there was Close button. when i clicked Close, I got my file with almost all the data lost including the formatting as well.

 

[Andrew Poulsom]

Shared workbooks are very prone to corruption. They are best avoided in my opinion. Sorry for the bad news.

 

[vijayendra.shukla]

Thanks Andrew for your reply. But you know, I never encountered this problem till today. Even when I replaced a new file, the same error occured. Isn't there something that is causing this error all of a sudden?

 

[Andrew Poulsom]

Sorry, I don't know the cause of the corruption. It's likely to be that more than one user is trying to save at the same time.

You may find this interesting:

http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/