Excel 2000 file when opened in Excel XP generates errors

[Guest]

Hi,

I have an Excel File that works fine in Excel 2000
in Excel 2003 first crashs, but the Patchs 892592/840316 or the office
service pack2 solved the problem
now i have the same problem in Excel XP - when i try to open the file, Excel
XP will crash. All Office XP updates until now are installed.

Thanks,
Gert

 

[dbarelli]

I think that you will have more answers in a diferent forum, this is
only for programming questions.
Rgds.

 

[Dave Peterson]

Each version of excel seems to handle corruption differently.

Usually (but not always), the newer versions of excel can open files that
earlier versions couldn't.

Lots of people have praised OpenOffice.org for saving their data and code.

http://www.openoffice.org, a 60-65 meg download or a CD

There are commercial recovery services. I've never used it, but you might want
to check into:
http://www.officerecovery.com

 

[Guest]

Try performing a "Save As..." into a new file and opening this new file in XP.

It seems that Excel continues to add garbage to files that are saved often
or that contain (a lot of) VBA code.

I had a similar problem on an XLA that bloated from 1.1Meg to 1.9Meg after
adding 1 line of code. This caused a crash in a few workstations runinng
Excel 2003 (XP and 2000 worked all fine) upon quitting.

With the VBA Editor open and my project visible on such PCs, Excel did not
crash.

Performing a "Save As.." the file dropped again to 1.1Meg and the problem
was solved on all computers.

Hope this helps.

Dutch