Re: German & English excel formula compatibility issues.

Hi,

we have had a similar problem with functions not translating correctly. The
XIRR function (INTZINSFUSS ) is part of the Analysis ToolPak" (In the "Tools
....Add-Ins" menu) which is available in both german and english (and prob
every other language) but it seems Excel is not always able to translate
these correctly as it does with the built-in functions. The only solution I
am able to offer (if it is one at all) is to use one Analysis ToolPak
(either German or Engish) across all offices. The Add-In files should be
located at ..\Programm Files\Microsoft
Office\Office10\Library\Analysis\ANALYS32.XLL on a more or less standard
installation.

Actually, the file description of the XLL says "language neutral" on my
machine (which prob means it doesn't work anywhere :-).

Regards
Max
maxxstirner@gmx.net



"Olly" <Ollyj@nospam.hotmail.com> schrieb im Newsbeitrag
news:#$Pwm4APDHA.3408@tk2msftngp13.phx.gbl...
> Hello,
>
> We have a problem with compatibility between formulas in German Excel 2002
> and English Excel 2002 in that the English XIRR function is actually
> INTZINSFUSS in German Excel.
>
> Our company has an office located in UK and Germany and they both need to
> share the same Excel files containing the XIRR function. Creating a
> duplicate file and doing "Find and Replace" each time a German user wants
to
> view a spreadsheet is most definitely not practical!
>
> Is there a way to configure German Excel 2002 to automatically recognize
the
> XIRR function as INTZINSFUSS.
>
> Please please help!
>
> Kind regards,
>
> Olly.
>
>
>