Cell Translation from German to English

[robkiolbasa]

Hello,

I am having a problem with a workbook that was created in a German version of excel, and is being opened with an English version of excel.

The specific cell that is causing the problems is coded as:
=CELL("Adresse",KF!AD5)
My expectation is that excel would translate this cell to:
=CELL("Address",KF!AD5)

If I manually change the german word "Adresse" to the english word "Address", it will work as expected. The problem with the manual translation is that when the German colleague tries to make updates, he will run into the same problem. We needs to to translate automatically when excel is opened. All other functions seem to translate as expected. Any suggestions on how to get this cell to translate properly?

Excel version is 2003, SP3 (11.8328.8329) , also the office proofing tools are installed with the German dictionaries.

 

[GlennUK]

As I understand it, if the English string for the info type is used, it will work in all languages, for example:

=ZELLE("address",a1)

in Dutch.