Excel marco not working outside USA

[jerseyvr6]

Excel Users....

I currently have an issue with some of my user defined functions. These functions work perfect for everyone here at my company in the USA / UK. The problem happens when we send it to our client who is overseas.

The client opens up the file and all they see are #VALUE! errors where our UDF's are being used. But when they send it back to us the file works properly.

I have currently added VBA code so that when the workbook and the user enables macro's the file will do an application.calculatefull. This still does not seem to work for them.

The excel version that I am running currently on my PC is MS Office 2003 Pro (11.8146.8132) SP2. The version that the client is running on their PC is MS Office 2003 Pro (11.8105.8107) SP2. Could this problem occur because of updates that they have not yet installed? I have been working on this problem for about a week now and have not come up with a solution.

So I was wondering if anyone has experienced this problem and if so what the cause of the problem is.

I would appreciate any insight that anyone can offer on this problem.

Thanks,

Justin

[royUK]

There could be language problems, this can cause problems with non-English versions of Excel.

[jerseyvr6]

There could be language problems, this can cause problems with non-English versions of Excel.

One of the countries that is experiencing the problem is Denmark. Thanks for the advice and i will look into the language and see if that is causing the problem.

Justin

[Dean England]

One problem is some foreign versions use ; instead of , when writing a formula. For whatever it's worth.

Dean

[royUK]

here's an article about the Analysis Toolpak and problems with non English versions

http://www.dailydoseofexcel.com/arch...-addin-part-1/