Excel in english vs french

[Sophie]

Hi,

I use some function from addins like analysis tools. My problem is that I
work with some english version of Excel (2000) and some french version.

When I send my french version to someone who have the english version, They
have an #nom? for result.

Could you help me ?

Thanks

Sophie

 

[Harald Staff]

Hi Sophie

This is one of the main reasons not to use the analysis toolpack functions.
They don't work in international environments. Which sounds irrelevantly
big, but this computer alone is an international environment, with several
Excel versions installed.

Frank Kabel made a list of replacement formulas, see
http://www.dicks-blog.com/archives/2004/12/18/replacing-the-analysis-toolpak-addin-part-1/

HTH. Best wishes Harald

 

[Sophie]

Thanks a lot Harald.

This is a very good advice. I'm sure that I'll find what I search.
Bye
Sophie