Compatibility Question

[jrwheels16]

I have created a file in Excel 2003, and saved as "Excel 97-Excel2003
&5.0/95 Workbook" and I am running XP.

The file utilizes several macros, VLOOKUP and COUNTIF commands.

My question is if this file is distributed throughout the general
public, what do you believe could be some unforeseen compatibility
issues I am not aware of as it will obviously be opened on several
versions of Operating Systems and versions of Excel?

Do I have a 50% chance of success that it will be compatible? What
would be your guess at the percentage of success?

What are my options to make it more successful throughout more OS
systems and Excel versions?

Will some type of compatibility pack be the answer?

Thanks for the anticipated help.
JR

 

[Niek Otten]

Hi JR,

It depends mostly on the macros and user forms. Excel's object model had some minor changes over the versions.
But I guess your chances are far above 90%, if you don't use versions older than Excel97.
Look here for a list of some changes:

http://www.j-walk.com/ss/excel/index.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have created a file in Excel 2003, and saved as "Excel 97-Excel2003
| &5.0/95 Workbook" and I am running XP.
|
| The file utilizes several macros, VLOOKUP and COUNTIF commands.
|
| My question is if this file is distributed throughout the general
| public, what do you believe could be some unforeseen compatibility
| issues I am not aware of as it will obviously be opened on several
| versions of Operating Systems and versions of Excel?
|
| Do I have a 50% chance of success that it will be compatible? What
| would be your guess at the percentage of success?
|
| What are my options to make it more successful throughout more OS
| systems and Excel versions?
|
| Will some type of compatibility pack be the answer?
|
| Thanks for the anticipated help.
| JR

 

[jrwheels16]

Niek,

Thanks for the info.

JR