Excel 2000 file when opened in Excel XP generates errors

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

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

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

Gert Unterhofer wrote:
>
> 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

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

"Gert Unterhofer" wrote:

> 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