Excel has stopped working

Hi

I have an Excel file with VBA procedures on which I was working - adding additional procedures. All was working fine. I closed the file and copied it as a back-up. When I tried to re-open the file it went through the start process but when it reached 100% it crashed with the message "Microsoft Excel has stopped working". It says Windows is looking for a solution but then a message box with just a stop icon and OK and Help buttons appears. Help goes to the usual Help dialog but doesn't suggest anything. OK sends the whole screen blank. If I open an earlier version, I get the list of "recovered" documents (including various "???.xlb" versions) but none of them work. They do appear on screen but then I get the message that they are corrupt and won't open.

I don't want to have to re-write what I most recently did and, worse, try to remember what other little edits I may have made to previous code. Is there any way to recover the file or is it lost forever? Or, is there any way of preventing this from happening?

Any advice would be much appreciated.

Mick

Hi

Nothing different from usual - modify code, test it (successfully, without any error messages), and close the file. But on opening, it crashes. I recall deleting a file of the (I assume random) name format, such as "3A381000". I assumed it was a left-over temporary/back-up file that Excel hadn't previously deleted, though I don't recall seeing anything similar previously. Could it have been the temporary file relating to the version of the file I was working on and I maybe deleted it before saving?

Can't think of anything else I did differently.

Cheers

Thanks.

Not wishing to appear ungrateful, but I'd rather not. Actually, while working on another file the "corrupt" file opened and I was able to export my VBA procedures and copy them into an earlier version. So, I've managed to recover the VBA and again have a working version. That doesn't relieve me of the concern that this may happen again and I will be unable to effect a recovery in this way.

Mick

Yes, agreed. It would be nice to know what was going on though. Thanks for the link. I'll check it out.

Much obliged!

I had the problem when converting a XLSM to a XLSB. Solved!

Problem:
Opening the XLSB would make Excel stop but opening it while another XLS open showed me a repair message "...Named range from ..." which gave me the hint

Solution:
- I removed all name definitions under Menue 'Formulas' => Name Manager in the original XLSM file
- saved as XLSB, closed all of Excel + the application
=> opening the XLSB works just fine.

then I wanted to know if all or just one of the ~16 name definitions caused the problem and found out that it was 1 particular name definition.
after deleting the one faulty name definition I re-created it in the XLSM, converted to XLSB
=> no problem.