Excel File corrupt and data lost

vijayendra.shukla

New Member
Joined
Jan 29, 2010
Messages
34
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.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Shared workbooks are very prone to corruption. They are best avoided in my opinion. Sorry for the bad news.
 

vijayendra.shukla

New Member
Joined
Jan 29, 2010
Messages
34
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,142
Messages
5,527,069
Members
409,742
Latest member
setam

This Week's Hot Topics

Top