Excel file unable to read from morning to afternoon

G

Guest

Here's one I'd like help figuring out. I've got a couple
of users with Excel 97 and 2K that save their files to
their home directory on shared server drive. On two
seperate occassions they both have been unable to open
files in the afternoon they worked on earlier in tht
moring on the same day. I am able to recover the files in
Excel 2002 but loose formating. Server hard drive cheecks
all integrity tests and it's been at least four weeks
since the last time it happened to these two. Help on this
would be appreciated.
 
D

Dave Peterson

First, if it happens again, you may have better luck recovering more stuff with
OpenOffice.

(http://www.openoffice.org, a 60-65 meg download or a CD)

But sometimes workbooks get corrupted. It might be time to recreate your
workbooks. I haven't had that much experience with corrupted workbooks, but I
did have a worksheet within a workbook that kept causing trouble.

I was luck enough to rebuild (and replace) that one worksheet and all's well so
far (knock wood!).
 
G

Guest

Here is a copy of the Excel repair log when attempting to
recover the document in Excel 2002.

Microsoft Excel File Repair Log

Errors were detected in
file '\\<Servername>\<username>\excel\excelfilename.xls'
The following is a list of repairs:

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.

Excel found errors that may cause some recovered data to
be put in the wrong cells. Please check your recovered
data carefully.
............................................................

What I don't understand is this user worked on multiple
files yesterday morning and only two of the files ended up
corupted. Ihad him check the others and he said they all
opened and looked fine but two he could not even open.
 
D

Dave Peterson

I have no idea why two workbooks were corrupted and the rest weren't. I think
I'd be ticked off that two were--and happy that only two were.

Corruption is really a workbook level event <bg>. (Although, you can damage
excel enough so that it can't open any workbook.)

So keep backups and find your installation CD--just in case!
 
Top