EXCEL Stability Revisited

[DRA]

I wrote:
It seems that EXCEL fails about every 15-29 minutes? Is this common? I'm
running Office 2007 on Vista Home.

More info per dwl:
I just tried to save a workbook and I get a message that says "Microsoft has
stopped working." It tries to recover my data and restarts Excel. I usually
have the VBA window open.

Help!

 

[Bernard Liengme]

That does not sound like a legitimate MS error message.

 

[DRA]

I miss typed":
"Microsoft Office Excel has stopped working."
Then:
"Microsoft Office Excel is trying to recover your data."
Then it restarts with some data recovered.
--
Thanks,
Don

That does not sound like a legitimate MS error message.

 

[Jon Peltier]

Excel 2007 is not as stable as earlier versions, but it doesn't fail for me
every 15-29 minutes, unless I happen to be using the same file again and
again. This indicates to me that there's some corruption in the workbook, so
I then try to rebuild it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

I miss typed":
"Microsoft Office Excel has stopped working."
Then:
"Microsoft Office Excel is trying to recover your data."
Then it restarts with some data recovered.

 

[DRA]

I tried to "re-build" then workbook by:
- Copying cells (not the sheets)
- Copying the macros by drag and dropping the module in the projects window
- Copying the userforms the same as macros.

I still had a failure when saving it.

Did I do the re-build wrong?

 

[Jon Peltier]

Perform these operations sequentially, with a save in between. I there any
one component which prevents the save? What if you perform the steps in a
different order?

- Jon

 

[DRA]

Triied some different combinations to no avail. I give up.

 

[Jon Peltier]

Maybe you could try the Repair option while opening the file. I don't know
how to invoke it, maybe from the Open File dialog.

- Jon