excel 2000 error when opening an xls file

K

Keith G Hicks

I just made some code and form modifications to an Excel 2000 file. One of
the sections of code creates a new worksheet in the workbook. Now every
time I try to open the Excel file I get the message

"EXCEL.exe has generated errors and will be closed by Windows. You will
need to restart the program. An error log has been created"

First of all, where is the error log? Sure would be nice if MS would tell
you where the log is in the message.

Secondly, there are forms, code, macros and menus in this file. Somethign
has become corrupt I fear. Is there any way to open the file without
anything running (like the shift key strategy in MS Access). I've tried
making a copy of the file. The copy behaves the same way. I could of
course redo all the changes I just made on an older copy, but would like to
avoid that.

All other Excel files open up just fine. No problem there. It's definitely
something in this particular file.

Any ideas here?

Thanks,

Keith
 
D

Dave Peterson

Just guesses...

Try opening in Safe mode.

Close excel
windows start button|Run
excel /safe

Maybe you can recover something that way.

You might be able to recover more by using another program--both xl2002 and
OpenOffice have better reputations for opening files that earlier versions of
excel couldn't.

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

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com
 
N

Norman Hinds

Keith said:
*I just made some code and form modifications to an Excel 2000 file.
One of
the sections of code creates a new worksheet in the workbook. No
every
time I try to open the Excel file I get the message

"EXCEL.exe has generated errors and will be closed by Windows. Yo
will
need to restart the program. An error log has been created"

First of all, where is the error log? Sure would be nice if MS woul
tell
you where the log is in the message.

Secondly, there are forms, code, macros and menus in this file.
Somethign
has become corrupt I fear. Is there any way to open the fil
without
anything running (like the shift key strategy in MS Access). I'v
tried
making a copy of the file. The copy behaves the same way. I coul
of
course redo all the changes I just made on an older copy, but woul
like to
avoid that.

All other Excel files open up just fine. No problem there. It'
definitely
something in this particular file.

Any ideas here?

Thanks,

Keith *
Click to expand...

Hi Keith,

To recover corrupted Excel files (incuding password protected) try thi
on-line servic
www.fdrlab.com[URL="http://

Good luc"]

Good luc[/url]
 
Top