Converting workbook to run on German excel

  • Thread starter Thread starter Fan924
  • Start date Start date
F

Fan924

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
 
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
Click to expand...

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.
 
See also the Useful links section on that page on the bottom
Click to expand...

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?
 
Back
Top