Compatibility Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jrwheels16@gmail.com - 09 Mar 2008 12:14 GMT

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

Reply to this Message

Niek Otten - 09 Mar 2008 13:26 GMT

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

Signature

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.
[quoted text clipped - 16 lines]
| Thanks for the anticipated help.
| JR

Reply to this Message

jrwheels16@gmail.com - 09 Mar 2008 15:59 GMT

Niek,

Thanks for the info.

JR

Reply to this Message