using Networkdays formula in French version of Excel options

M

mel.pilgrim

I have a spreadsheet that I have several references to the formula
'Networkdays'. The spreadsheet works great using the English version
of Excel however, I have collegues that use a French copy of Excel and
the spreadsheet does not function using that version of Excel.

In order to get the spreadsheet to work, I have to change all the
references in the spreadsheet from 'Networkdays' to 'NB.JOURS.OUVRES'
and then it will work.

Is there anyway I can set up the spreadsheet so that it will work in
both languages without having to re-write the formual for different
versions of Excel? Maybe a statement 'if Excel ver=French, use
NB.JOURS.OUVRES, if English use Networkdays'?
thx

Mel
 
M

MichaelH

I'm having the same issue with spreadsheets developed in English versio
EXCEL2003, being used in Germany. Anyone know why the Analysis Tool Pa
functions aren't translated automatically like all the "standard
functions?

Can anyone suggest a good fix - I don't want to maintain multipl
versions of the same spreadsheet?

My own thoughts are to create a new UDF... xNETWORKDAYS() and withi
that, use the VBA function equivalent. However, since it would com
from the add-in file atpvb*EN*.xls (where *EN* refers to English), wil
I just end up with the same "not translated" issue? Will my Germa
colleagues have an atpvba*DE*.xls to install the toolpack and again if
call the funciton in "english" it will fail?

Apprectiate any help.
 
M

MichaelH

Mmmm! Having difficulty getting those formulae to work. But I wil
persevere. Thanks.

Was I right about the ATP VBA functions, would I have come up with th
same problem if I'd tried to "code" a UDF and then send that t
Germany?
 
N

Niek Otten

<would I have come up with the same problem if I'd tried to "code" a UDF and
then send that to Germany?>

Probably. But sometimes Excel and its international issues surprise me.

You can easily test that, I assume.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula or macro to change a formula in muliple spreadsheets 1
Add additional information to excel form after original data entry 0
Need Help with Macro Security 1
Excel - Wich Function should I use? 1
Export BPMN Visio Chart to Excel 0
Dumb question alert! What program to use? 0
Integrating information from Word to Excel (not mail merge) 1
Using Office Forms and dynamically updating the excel backend 0

Top