Regional differences

Hi All,

I have a spreadsheet that is used by other employees of my company all over the world. Recently, I have been getting reports that the spreadsheet is not working properly; first from South America (Brazil) and now from Germany.

It is a fairly large spreadsheet and has several macros. Some of the initial problems were due to the macro security level being set too high, but for some users, reducing the security level hasn't helped. The basic complaint is that the pull-down menus on the first sheet do not work properly.

I'm unable to reproduce the problem here, and the spreadsheet works fine on any local computer that I've tried it on.

I'm currently using Microsoft Excel 2003 SP 2 and Windows XP Professional version 2002 SP 2. All of my computer settings are US-English.

Any suggestions on where I can find information on what I can do to get this spreadsheet to work properly in different regions and/or with different versions of Windows/Office?

Thanks

I once made a spreadsheet which included a lot of calculation with complex numbers. This was done in an english version of Excel, so complex was of course spelled "COMPLEX". Then I brought this spreadsheet to a danish version of Excel, but even if "AVG" was translated to "MIDDEL" and "IF" to "HVIS", etc., I had to replace all the complex formulas, because "COMPLEX" was NOT translated to "KOMPLEX", which is the way it is spelled in danish (and german). Apparently not all expressions are covered by the translation, and if your macros contain some, then you might see problems.

I've noticed that in macros you must write like this: ActiveCell.FormulaR1C1 = "=NORMSINV(((ROW()-1)-0.5)/R1C[2])". The finished formula on the spreadsheet will not show the word ROW, but rather REIHE, or whatever they call it in german. But such a translation might not always take place - at least it does not work with COMPLEX between danish and english.

NSV