EXCEL 97 File Save/Open Error

I have started getting the following error either as I save a file after making changes or when I am trying to open a file saved after a certain time, but it doesn't happen on files I have saved prior to a certain point in time.

I can open files saved prior to that time, but now when I save after changes I get the message again.

Clicking "OK" kicks me out of Excel completely and the file is then inaccessible.

"Excel has casued an error in EXCEL.EXE.
Excel willnow close.

If you continue to experience problems, try restarting your computer."

Any ideas on why this is happening?

First off, that's a horrible problem, and it sounds like a registry screw up to me. Usually you see something like that happen and you reboot and it goes away, that means the registry's OK. In your case it sounds as if the registry is actually loading the problem in, or another recently added program is interfering with the excel registry.
But "when you hear hoofbeats think horses not zebras" as they say in the medical profession. That is try to solve as if you have the most likely problem before attacking the exotic one, so I'd try an uninstall reinstall before I did anything else.
Uninstall through the control panel "add remove programs" applet, REBOOT, and then reinstall, and then REBOOT again to see if that fixes it.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

EXCEL 97 File Save/Open Error

Registry SNAFU? Uninstall and reinstall Office