Discussion:
Excel 2000 file when opened in Excel XP generates errors
(too old to reply)
Gert Unterhofer
2006-02-20 11:23:27 UTC
Permalink
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
2006-02-20 13:29:32 UTC
Permalink
I think that you will have more answers in a diferent forum, this is
only for programming questions.
Rgds.;)
--
dbarelli
------------------------------------------------------------------------
dbarelli's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31275
View this thread: http://www.excelforum.com/showthread.php?threadid=514357
Dave Peterson
2006-02-20 16:02:23 UTC
Permalink
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
Post by Gert Unterhofer
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
--
Dave Peterson
Dutch Gemini
2006-03-02 10:03:27 UTC
Permalink
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
Post by Gert Unterhofer
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
Loading...