General discussion

Locked

Excel-2000 workbooks in Excel-97

By gskiaker ·
We?re using Excel-2000 to develop spreadsheets that we use in our test software. But some of our customers has not upgraded to Office-2000 yet, so we need to load the 2000 xls in Excel-97. But Excel-97 crashes when loading the spreadsheet that was saved with Excel-2000. The Excel-2000 spreadsheet has some VBA code in them. This happens on several different computers with Excel-97, and with Excel-2000 spreadsheets from different computers. The PC?s with Excel-97 loaded on them are running Windows NT 4.0, so when Excel-97 crashes, Dr. Watson catch the application error. The error message is: Excel.exe ? Exception: access violation (0xc0000005), Address: 0x300905d8 (I have the drwatson.log file, if anyone is interested). I know that Excel-97 is supposed to be forward compatible with Excel-2000, but why don?t it work backward? Anyone with any ideas?

Thank you,

Gus Skiaker
Project Engineer
Titan Inc.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel-2000 workbooks in Excel-97

by trish_tschirn In reply to Excel-2000 workbooks in E ...

Mr. Skiaker,

When saving the file, try doing a save as instead and chosing the option to save as a 95/97/2000 file.

Trish Tschirn
ISO
BCI, Inc.

Collapse -

Excel-2000 workbooks in Excel-97

by gskiaker In reply to Excel-2000 workbooks in E ...

Tried that - didn't work. Any other suggestion?

Collapse -

Excel-2000 workbooks in Excel-97

by mbazzell In reply to Excel-2000 workbooks in E ...

I am not sure why it is totally crashing, but I will tell you that the VBA does not work backwards!

When you program the VBA in 2000 and then try to use it in 97 you will receive an error.

I had the same problem. Then I took my spreadsheet to a 97 machine and debugged it, so that it would work with 97.

You can go from 97 to 2000 just fine with the VBA.

Collapse -

Excel-2000 workbooks in Excel-97

by gskiaker In reply to Excel-2000 workbooks in E ...

Poster rated this answer

Collapse -

Excel-2000 workbooks in Excel-97

by SanKulPune In reply to Excel-2000 workbooks in E ...

Hi,
The simplest and safest option, in my view, is to develope code using 97 and distribute it. It will work on 2000. When everybody starts using 2000, shift everything to 2000.

Regrds,

Sanjay Kulkarni

Collapse -

Excel-2000 workbooks in Excel-97

by gskiaker In reply to Excel-2000 workbooks in E ...

Poster rated this answer

Collapse -

Excel-2000 workbooks in Excel-97

by gskiaker In reply to Excel-2000 workbooks in E ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums