Excel 2000/Outlook 2000 created, but used by 97 and 98

[mts176]

I created an Excel workbook in 2000 with all of the necessary refereneces to be able to use Outlook to send an email. The workbook and functions work fine on my machine, but when others in my office with older versions of Excel and Outlook try to use it, the function dont work.

The ideal fix would to upgrade everyone but cost restraints don't make that possible. Is there any work around?

Half of the office is 2000 and above, other half is Win NT, Outlook 98, Office 97, with some misc. floating around.

Any help would be fantastic.

Thanks

Mike

 

[tchatzi]

I don't think that you can make something in a newer version and expect it to work in an older version.

BUT try, while you have the 'myexcelworkbook.xls' open

to go File->Save As

and then at

Save as Type :

choose 'Microsoft Excel 97-2002 & 5.0/95 Workbook(*.xls)'

it might work, if it doesn't then you have to install 2000 to every pc you want to use it.

Good Luck