File error: data loss possible

M

mbobro

hi,

I get such a kind of error communicate while opening a workbook. (tha
is free translation from my native language, so it might not be a ver
accurate translation)

When I look at file I can't see any data loss. If I lose the wrokboo
and reopen it, the error is still there. But, when I open, save an
reopen - it's ok.

So I opened and saved and seemed to be ok. What a surprise when afte
some VBA formating task and saving it again with a different name afte
opening it I have found error again.

Any ideas what's going on?


Regards,

Micha
 
D

Dave Peterson

I've seen errors like this that pop up when excel is opening a corrupted
workbook (or a workbook with at least one corrupted worksheet).

You may want to start recreating your workbook. If you wait too long and have
trouble even opening the file, you may be able to use openoffice to get to your
data. It has a pretty good reputation for opening files that excel couldn't.

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

And you could try a different version of excel to get to your data. Each
version seems to be sensitive to different things (from what I've read in the
newsgroups.)

I don't mean to be alarmist, but keep backups and if that file is important,
spend some time now--don't wait for it to get bad enough so you can't open it
all.
 
M

mbobro

David,

Thanks for your suggestions :) Especially opening xls with openoffice
is a bright idea.

Coming back to my case I have no trouble at all while opening the file
- everything is ok, I do not wait and the only sympthom is a pop-up.
Moreover, as I said in my previous mail, once you save this 'corrupted'
workbook even pop-up disappears and everything is ok.

But at the end of the day the most suprising for me is that when I save
the workbook, close it and reopen (no error pop-up) and then do some
font and cells filling formating changes the error pop-up window comes
back. Really strange for me.

I feel you might be right with the suggestions that the file has one
corrupted worksheet. If fact, while reprocessing it I add and delete
some worksheets. Maybe one of them is corrupted. But still, when I do
formatting I do it on one worksheet workbook and still error comes
back.


Michal
 
D

Dave Peterson

I haven't had that much experience with corrupted workbooks/worksheets, but the
one time I remember having lots of trouble it was with a worksheet that had tons
of unique formatting and lots of comments.

I ended up just recreating that one worksheet (going to a much more vanilla
formatting style) and losing most (all?) of the comments.

It's been good ever since.

If you're using lots of different formats, you may want to see if you can apply
the formatting to whole rows/columns.

Good luck,
 
Top