I have a rather large workbook made on an US version of excel 97. It
requires the add-in Analysis ToolPak since I use functions HEX2DEC &
DEC2HEX.

When run by a friend in Germany, he gets #name errors everywhere. This
is the first that I am aware of this, that German excel uses different
spelling for function names. HEX2DEC is HEXINDEZ in German.

Is there an application that will convert the entire worksheet so that
it will run with German excel?

Hi Fan924

See this page
http://www.rondebruin.nl/international.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Fan924" wrote in message ...
I have a rather large workbook made on an US version of excel 97. It
requires the add-in Analysis ToolPak since I use functions HEX2DEC &
DEC2HEX.

When run by a friend in Germany, he gets #name errors everywhere. This
is the first that I am aware of this, that German excel uses different
spelling for function names. HEX2DEC is HEXINDEZ in German.

Is there an application that will convert the entire worksheet so that
it will run with German excel?

See also the Useful links section on that page on the bottom

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Fan924" wrote in message ...
I have a rather large workbook made on an US version of excel 97. It
requires the add-in Analysis ToolPak since I use functions HEX2DEC &
DEC2HEX.

When run by a friend in Germany, he gets #name errors everywhere. This
is the first that I am aware of this, that German excel uses different
spelling for function names. HEX2DEC is HEXINDEZ in German.

Is there an application that will convert the entire worksheet so that
it will run with German excel?

Hi Fan924
You could use "Find & Replace" in the edit menu.
Play with a copy not your original, just to make sure everything is working ok.
HTH
John
"Fan924" wrote in message
...
I have a rather large workbook made on an US version of excel 97. It
requires the add-in Analysis ToolPak since I use functions HEX2DEC &
DEC2HEX.

When run by a friend in Germany, he gets #name errors everywhere. This
is the first that I am aware of this, that German excel uses different
spelling for function names. HEX2DEC is HEXINDEZ in German.

Is there an application that will convert the entire worksheet so that
it will run with German excel?

On Nov 12, 1:55*pm, "John" wrote:
Hi Fan924
You could use "Find & Replace" in the edit menu.
Play with *a copy not your original, just to make sure everything is working ok.
HTH
John

Hi John,

Did that a few days ago. Replaced with german DEZINHEX & HEXINDEZ. It
did not work. There must be other differences that I am not aware of.
I do not have a german copy of excel so I can't test it.

On Nov 12, 1:43*pm, "Ron de Bruin" wrote:
See also the Useful links section on that page on the bottom

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

Thanks Ron,

I found this on that page, "Analysis ToolPak Translator 7.0"
There is a "Bi-Directional Translator" in it but have not figured out
how to make it work.

The funtion names may not be the only problem.
Is VBA code from a US excel version going to work in a German copy of
excel?