Excel Crashes Upon Opening

J

Jason

I am using Excel 2002. Recently I have been having problems opening certain
files. When I open the file, it opens up half way and then a pop up box
comes up which says "Microsoft Excel has encountered a problem and needs to
close. We're sorry for any inconvenience". I then have the option of
sending the error report to microsoft, and excel automatically recovers the
file. The strange thing is that this happens periodically, there are times
when this error occurs and other times when it doesn't.

Another point to note is that I have also tried opening the file, but
setting the calculation mode to manual before doing so. When I do this, the
file opens up fine, but as soon as I change calculation mode back to manual,
I get the pop up box and the same thing as above occurs.

Anyone have any thoughts as to what might be going on or any potential
resolutions?
 
D

Dave Peterson

Some people have reported that opening in openoffice and saving there--then
opening in excel can sometimes help.

But it's a big download:
http://www.openoffice.org, a 60-65 meg download or a CD

===
Just things to try.

copy your workbook -- don't destroy the original!

open it with calculation set to manual.

One by one, move a sheet to a new workbook and save both the single sheet
workbook and the original (minus the worksheet) workbook.

Then close both and reopen the original. Toggle calculation.

If you find that after a you remove a worksheet, excel doesn't crash, then maybe
you've isolated the problem in the workbook (on that sheet you just moved).

make another copy of the original (and dump all those experiments!).

Open that copy with calc mode set to manual, move the problem workbook out and
save both workbooks.

Close the original (minus the bad worksheet).

Recreate the problem worksheet in a new workbook.
Copy|paste special|formulas
add range names
print setup
and match the Worksheet name, too!
all that junk!

close the extracted problem workbook and delete it.

Save the rebuilt one with the same name as the one you just deleted. Open up
the original (with the one sheet missing) and put that sheet back in.

If you're lucky, then you may have fixed that error.

Here's hoping that there's only one worksheet with a problem!

And if things go really bad, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com

Formulas
 
P

Puskas

Another option to repair damaged excel files is to use a software
download. One is excelfix found at http://www.cimaware.com, normally
better than services that will use older versions of the same software
 
Top