Question about locale in formulae

  • Thread starter Thread starter John Fenton
  • Start date Start date
J

John Fenton

The CFO of our German location uses a US laptop with US Excel 2003. When he
emails a spreadsheet with some complex formulas using things like End of
Month, the expression used in US is not the same as German. When he
receives a file from the German accounting office, they use their
expressions on their German Excel spreadsheets which don't work properly on
the US Excel 2003.

Is there a way to get these spreadsheets to "learn" each locales'
expressions and finctions or do we need to install the US version of Excel
on the German computers and then add German in the Office Language settings
tool? I'm not sure that would work anyway.

Any help would be appreciated.

Thanks,

John
 
Hi John,

All native Excel formulas and functions will be translated automatically.
EOMONTH, however, is an Analysis Toolpak function, which will not be
translated automatically.
EOMONTH can be replaced easily using native Excel functions (first day of
next month minus one day), but in general you'll have to translate add-in
functions manually.
Translations of Excel and ATP functions can be found at

http://www.acoustics-noise.com/

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
LOL - That was my initial reaction Niek, but the OPs text doesn't sound right
when he says it works both ways because I could see whoever doesn't have it
installed having problems opening spreadsheets from the one that does, but not
the other way round.
 
So,

The US user can't open a German spreadsheet that is using German Analysis
Toolpack functions

and

The German user cannot open the US spreadsheet that is using US Analysis
Toolpack functions

Is this correct?


John
 
Hi
both users can OPEN the file but the formula will shoe #NAME instead of
the correct result
 
Hello Niek,

It's been a while. :):)

Just for info (if you didn't know already)

The tool you referred to doesn't need manual conversion of the
Analysis ToolPak functions.
http://www.acoustics-noise.com/ATPtranslator.shtml
It localizes the MS Excel documents automatically at the receiver side
just by pressing 1 menu command.

The latest edition even allows to enter 1 single VBA code line in an
Auto_Open procedure in the file, which causes the localization
procedure to work automatically (within the 11 languages covered by
the utility) without any users intervention at all.

Of course one still can use the integrated bi-directional translation
utility to do it manually, but then one doesn't use the power the
utility is designed for.

Warm regards
Eric

PS: I still haven't forgotten the energy you put in trying to help me
long ago for which my respect and thanks.
 
Back
Top