Excel crashes when opening file

[Miss Muffet]

RE: Excel 2000 - Windows 2000

We have a huge file we use for reporting purposes. This
file would crash every now and then when all the numbers
are already entered which causes a bit of upset in the
office.

The error is always:
EXCEL.EXE
The instruction at "0x300844da" referenced memory
at "0x00001034". The memory could not be "read".
Click on OK to terminate the program.

The only way out would be to click OK, and thus shutting
down Excel entirely.

Our only recourse when this happens is to re-enter all the
values and hope that it does not crash again.

It does not matter which computer this is opened nor does
it matter who opens it.

I switched the calculation to "Manual" before opening and
had tried to do <ctrl><PageDown> but no luck.

Does anyone have any idea on what would cause this
workbook to crash?

Is there a way to repair such corrupted workbooks?

 

[Jan Karel Pieterse]

Hi Miss,

We have a huge file we use for reporting purposes. This
file would crash every now and then when all the numbers
are already entered which causes a bit of upset in the
office.

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set macro security
to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button, press
control-pageup or control-pagedown, thus changing sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you for a sheet
name.

Sometimes the Excel viewer, Word or even Internet explorer (v5) enables
you to open the file and copy information out of it.

If the file is not protected, maybe you can open it with OpenOffice
(www.Openoffice.org).

Also, Excel XP can sometimes repair XL files with trouble.

Finally, sometimes a corrupt file that still can be opened,
can be cured using this method (XL2000 or up):

- Open the file
- Save-as filetype Webpage
- close the file
- Open the html file
- save-as normal Excel workbook.


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Xcitednewmommy]

Thanks for this tip! I had an Excel file that was over 5MB
that contained Macros. Each time I attempted to open this
file it would stall, ask for the password then time out or
just hang. CNTL+ALT+Del showed the file/program as not
responding. Your excellent tip allowed me to extract
little by little the cell data from the corrupt workbook
into a new one. I have been attempting to open this file
for over 6 months now and your advice did the trick.

Thanks for all you knowledge and willingness to share.

--xcitednewmommy
12/22/2003

-----Original Message-----
Hi Miss,

We have a huge file we use for reporting purposes. This
file would crash every now and then when all the numbers
are already entered which causes a bit of upset in the
office.

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set macro security
to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button, press
control-pageup or control-pagedown, thus changing sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you for a sheet
name.

Sometimes the Excel viewer, Word or even Internet explorer (v5) enables
you to open the file and copy information out of it.

If the file is not protected, maybe you can open it with OpenOffice
(www.Openoffice.org).

Also, Excel XP can sometimes repair XL files with trouble.

Finally, sometimes a corrupt file that still can be opened,
can be cured using this method (XL2000 or up):

- Open the file
- Save-as filetype Webpage
- close the file
- Open the html file
- save-as normal Excel workbook.


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

.