Can't read Dutch written equations in excel files. Could before..

I've recently upgraded from the previous USA Office XP 2002 to USA Office XP
2003.

In office XP 2002 I was able to use our company's excel file that comes from
Holland. All the equations in the excel file are written in Dutch. Here's
an example:

=IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"")

Now, in Office XP 2003 the contents of this equation produces #NAME?. I
can't seem to find any type of language setting or addon package that
corrects this. Nor can I seem to find out what language changes have been
made between the two versions.

I've had multiple different installations of XP 2002 on different computers
all able to "translate" these equations so that tells me it wasn't unique to
just 1 install. How do I get XP 2003 to recognize these equations?

Any help would be greatly appreciated.

Hi MMS USA

If = Als in Dutch
You can send me the file private and I will test it for you



--
Regards Ron de Bruin
http://www.rondebruin.nl



"MMS USA" <MMS [email protected]> wrote in message
news:[email protected]...
> I've recently upgraded from the previous USA Office XP 2002 to USA Office
> XP
> 2003.
>
> In office XP 2002 I was able to use our company's excel file that comes
> from
> Holland. All the equations in the excel file are written in Dutch.
> Here's
> an example:
>
> =IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"")
>
> Now, in Office XP 2003 the contents of this equation produces #NAME?. I
> can't seem to find any type of language setting or addon package that
> corrects this. Nor can I seem to find out what language changes have been
> made between the two versions.
>
> I've had multiple different installations of XP 2002 on different
> computers
> all able to "translate" these equations so that tells me it wasn't unique
> to
> just 1 install. How do I get XP 2003 to recognize these equations?
>
> Any help would be greatly appreciated.
>

Thank you, but this information is too sensitive to send. As you can see, If
is already used in the equations, not Als. These are Dutch words for things
like sum, etc. that the US version is not recognzing.

I'm looking to understand what makes 2002 read these equations and 2003 not.

Are there language updates that may not be in the 2003 install?

"Ron de Bruin" wrote:

> Hi MMS USA
>
> If = Als in Dutch
> You can send me the file private and I will test it for you
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "MMS USA" <MMS [email protected]> wrote in message
> news:[email protected]...
> > I've recently upgraded from the previous USA Office XP 2002 to USA Office
> > XP
> > 2003.
> >
> > In office XP 2002 I was able to use our company's excel file that comes
> > from
> > Holland. All the equations in the excel file are written in Dutch.
> > Here's
> > an example:
> >
> > =IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"")
> >
> > Now, in Office XP 2003 the contents of this equation produces #NAME?. I
> > can't seem to find any type of language setting or addon package that
> > corrects this. Nor can I seem to find out what language changes have been
> > made between the two versions.
> >
> > I've had multiple different installations of XP 2002 on different
> > computers
> > all able to "translate" these equations so that tells me it wasn't unique
> > to
> > just 1 install. How do I get XP 2003 to recognize these equations?
> >
> > Any help would be greatly appreciated.
> >
>
>
>

Hi

All normal Excel functions will translate(also in 2003)
Only the ATP Add-in functions not.

For a file with translations see (FuncRefXLv4-0 from Norman Harker)
http://www.contextures.com/functions.html


--
Regards Ron de Bruin
http://www.rondebruin.nl



"MMS USA" <MMS [email protected]> wrote in message
news:[email protected]...
> Thank you, but this information is too sensitive to send. As you can see,
> If
> is already used in the equations, not Als. These are Dutch words for
> things
> like sum, etc. that the US version is not recognzing.
>
> I'm looking to understand what makes 2002 read these equations and 2003
> not.
>
> Are there language updates that may not be in the 2003 install?
>
> "Ron de Bruin" wrote:
>
>> Hi MMS USA
>>
>> If = Als in Dutch
>> You can send me the file private and I will test it for you
>>
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "MMS USA" <MMS [email protected]> wrote in message
>> news:[email protected]...
>> > I've recently upgraded from the previous USA Office XP 2002 to USA
>> > Office
>> > XP
>> > 2003.
>> >
>> > In office XP 2002 I was able to use our company's excel file that comes
>> > from
>> > Holland. All the equations in the excel file are written in Dutch.
>> > Here's
>> > an example:
>> >
>> > =IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"")
>> >
>> > Now, in Office XP 2003 the contents of this equation produces #NAME?.
>> > I
>> > can't seem to find any type of language setting or addon package that
>> > corrects this. Nor can I seem to find out what language changes have
>> > been
>> > made between the two versions.
>> >
>> > I've had multiple different installations of XP 2002 on different
>> > computers
>> > all able to "translate" these equations so that tells me it wasn't
>> > unique
>> > to
>> > just 1 install. How do I get XP 2003 to recognize these equations?
>> >
>> > Any help would be greatly appreciated.
>> >
>>
>>
>>

Well, I would have to say they don't. Otherwise this would not be a problem.

Is anyone else seeing this issue?

"Ron de Bruin" wrote:

> Hi
>
> All normal Excel functions will translate(also in 2003)
> Only the ATP Add-in functions not.
>
> For a file with translations see (FuncRefXLv4-0 from Norman Harker)
> http://www.contextures.com/functions.html
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "MMS USA" <MMS [email protected]> wrote in message
> news:[email protected]...
> > Thank you, but this information is too sensitive to send. As you can see,
> > If
> > is already used in the equations, not Als. These are Dutch words for
> > things
> > like sum, etc. that the US version is not recognzing.
> >
> > I'm looking to understand what makes 2002 read these equations and 2003
> > not.
> >
> > Are there language updates that may not be in the 2003 install?
> >
> > "Ron de Bruin" wrote:
> >
> >> Hi MMS USA
> >>
> >> If = Als in Dutch
> >> You can send me the file private and I will test it for you
> >>
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "MMS USA" <MMS [email protected]> wrote in message
> >> news:[email protected]...
> >> > I've recently upgraded from the previous USA Office XP 2002 to USA
> >> > Office
> >> > XP
> >> > 2003.
> >> >
> >> > In office XP 2002 I was able to use our company's excel file that comes
> >> > from
> >> > Holland. All the equations in the excel file are written in Dutch.
> >> > Here's
> >> > an example:
> >> >
> >> > =IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"")
> >> >
> >> > Now, in Office XP 2003 the contents of this equation produces #NAME?.
> >> > I
> >> > can't seem to find any type of language setting or addon package that
> >> > corrects this. Nor can I seem to find out what language changes have
> >> > been
> >> > made between the two versions.
> >> >
> >> > I've had multiple different installations of XP 2002 on different
> >> > computers
> >> > all able to "translate" these equations so that tells me it wasn't
> >> > unique
> >> > to
> >> > just 1 install. How do I get XP 2003 to recognize these equations?
> >> >
> >> > Any help would be greatly appreciated.
> >> >
> >>
> >>
> >>
>
>
>

Well, I would say the only functions that did NOT translate in your formula were
the ones belonging to the Analysis Toolpak (ATP). Which is exactly what Ron
told you.

The ALS() got translated to IF()
the AFRONDEN.N.VEELVOUD() did NOT translate to MROUND()

This is a known Excel shortcoming.

Solutions:
==========
1. Have a name (Ctrl-F3) defining the langage (Lang="Dt" or "Eg" or
whatever) and have your formulas containing ATP functions wrapped-written like
this : IF(Lang="Dt", dutch_formula, english_formula)
In this scenario, the name has to be set on the Workbook_Open event
using Application.International(xlCountryCode) result

2. Use http://www.acoustics-noise.com/ATPtranslator.shtml

3. Bypass ATP functions (either by using other 'normal' functions or VBA code)
For instance, MROUND(A1,A2) can be replaced by =ROUND(A1/A2,)*A2

Regards,

Daniel M.

"MMS USA" <MMS [email protected]> wrote in message
news:[email protected]...
> Well, I would have to say they don't. Otherwise this would not be a problem.
>
> Is anyone else seeing this issue?
>
> "Ron de Bruin" wrote:
>
> > Hi
> >
> > All normal Excel functions will translate(also in 2003)
> > Only the ATP Add-in functions not.
> >
> > For a file with translations see (FuncRefXLv4-0 from Norman Harker)
> > http://www.contextures.com/functions.html
> >
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> >
> > "MMS USA" <MMS [email protected]> wrote in message
> > news:[email protected]...
> > > Thank you, but this information is too sensitive to send. As you can see,
> > > If
> > > is already used in the equations, not Als. These are Dutch words for
> > > things
> > > like sum, etc. that the US version is not recognzing.
> > >
> > > I'm looking to understand what makes 2002 read these equations and 2003
> > > not.
> > >
> > > Are there language updates that may not be in the 2003 install?
> > >
> > > "Ron de Bruin" wrote:
> > >
> > >> Hi MMS USA
> > >>
> > >> If = Als in Dutch
> > >> You can send me the file private and I will test it for you
> > >>
> > >>
> > >>
> > >> --
> > >> Regards Ron de Bruin
> > >> http://www.rondebruin.nl
> > >>
> > >>
> > >>
> > >> "MMS USA" <MMS [email protected]> wrote in message
> > >> news:[email protected]...
> > >> > I've recently upgraded from the previous USA Office XP 2002 to USA
> > >> > Office
> > >> > XP
> > >> > 2003.
> > >> >
> > >> > In office XP 2002 I was able to use our company's excel file that comes
> > >> > from
> > >> > Holland. All the equations in the excel file are written in Dutch.
> > >> > Here's
> > >> > an example:
> > >> >
> > >> >
=IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.
N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<
20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),
"")
> > >> >
> > >> > Now, in Office XP 2003 the contents of this equation produces #NAME?.
> > >> > I
> > >> > can't seem to find any type of language setting or addon package that
> > >> > corrects this. Nor can I seem to find out what language changes have
> > >> > been
> > >> > made between the two versions.
> > >> >
> > >> > I've had multiple different installations of XP 2002 on different
> > >> > computers
> > >> > all able to "translate" these equations so that tells me it wasn't
> > >> > unique
> > >> > to
> > >> > just 1 install. How do I get XP 2003 to recognize these equations?
> > >> >
> > >> > Any help would be greatly appreciated.
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >

Hi Daniel

I like to have his old Excel 2002 version that do the translations<vbg>

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Daniel.M" <[email protected]> wrote in message
news:[email protected]...
>
> Well, I would say the only functions that did NOT translate in your
> formula were
> the ones belonging to the Analysis Toolpak (ATP). Which is exactly what
> Ron
> told you.
>
> The ALS() got translated to IF()
> the AFRONDEN.N.VEELVOUD() did NOT translate to MROUND()
>
> This is a known Excel shortcoming.
>
> Solutions:
> ==========
> 1. Have a name (Ctrl-F3) defining the langage (Lang="Dt" or "Eg" or
> whatever) and have your formulas containing ATP functions wrapped-written
> like
> this : IF(Lang="Dt", dutch_formula, english_formula)
> In this scenario, the name has to be set on the Workbook_Open event
> using Application.International(xlCountryCode) result
>
> 2. Use http://www.acoustics-noise.com/ATPtranslator.shtml
>
> 3. Bypass ATP functions (either by using other 'normal' functions or VBA
> code)
> For instance, MROUND(A1,A2) can be replaced by =ROUND(A1/A2,)*A2
>
> Regards,
>
> Daniel M.
>
> "MMS USA" <MMS [email protected]> wrote in message
> news:[email protected]...
>> Well, I would have to say they don't. Otherwise this would not be a
>> problem.
>>
>> Is anyone else seeing this issue?
>>
>> "Ron de Bruin" wrote:
>>
>> > Hi
>> >
>> > All normal Excel functions will translate(also in 2003)
>> > Only the ATP Add-in functions not.
>> >
>> > For a file with translations see (FuncRefXLv4-0 from Norman Harker)
>> > http://www.contextures.com/functions.html
>> >
>> >
>> > --
>> > Regards Ron de Bruin
>> > http://www.rondebruin.nl
>> >
>> >
>> >
>> > "MMS USA" <MMS [email protected]> wrote in message
>> > news:[email protected]...
>> > > Thank you, but this information is too sensitive to send. As you can
>> > > see,
>> > > If
>> > > is already used in the equations, not Als. These are Dutch words for
>> > > things
>> > > like sum, etc. that the US version is not recognzing.
>> > >
>> > > I'm looking to understand what makes 2002 read these equations and
>> > > 2003
>> > > not.
>> > >
>> > > Are there language updates that may not be in the 2003 install?
>> > >
>> > > "Ron de Bruin" wrote:
>> > >
>> > >> Hi MMS USA
>> > >>
>> > >> If = Als in Dutch
>> > >> You can send me the file private and I will test it for you
>> > >>
>> > >>
>> > >>
>> > >> --
>> > >> Regards Ron de Bruin
>> > >> http://www.rondebruin.nl
>> > >>
>> > >>
>> > >>
>> > >> "MMS USA" <MMS [email protected]> wrote in message
>> > >> news:[email protected]...
>> > >> > I've recently upgraded from the previous USA Office XP 2002 to USA
>> > >> > Office
>> > >> > XP
>> > >> > 2003.
>> > >> >
>> > >> > In office XP 2002 I was able to use our company's excel file that
>> > >> > comes
>> > >> > from
>> > >> > Holland. All the equations in the excel file are written in
>> > >> > Dutch.
>> > >> > Here's
>> > >> > an example:
>> > >> >
>> > >> >
> =IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.
> N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<
> 20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),
> "")
>> > >> >
>> > >> > Now, in Office XP 2003 the contents of this equation produces
>> > >> > #NAME?.
>> > >> > I
>> > >> > can't seem to find any type of language setting or addon package
>> > >> > that
>> > >> > corrects this. Nor can I seem to find out what language changes
>> > >> > have
>> > >> > been
>> > >> > made between the two versions.
>> > >> >
>> > >> > I've had multiple different installations of XP 2002 on different
>> > >> > computers
>> > >> > all able to "translate" these equations so that tells me it wasn't
>> > >> > unique
>> > >> > to
>> > >> > just 1 install. How do I get XP 2003 to recognize these
>> > >> > equations?
>> > >> >
>> > >> > Any help would be greatly appreciated.
>> > >> >
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >
>
>

Thanks Daniel and Ron, however, Daniel, the link for the prog on the page you
offered seems to bring me to a forbidden area. Can't get the Analysis
ToolPack translator 7.0.

HOWEVER, I did perform a replace all on AFRONDEN.N.VEELVOUD and changed them
to ROUND and it worked.

Thanks for your help!

"Ron de Bruin" wrote:

> Hi Daniel
>
> I like to have his old Excel 2002 version that do the translations<vbg>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Daniel.M" <[email protected]> wrote in message
> news:[email protected]...
> >
> > Well, I would say the only functions that did NOT translate in your
> > formula were
> > the ones belonging to the Analysis Toolpak (ATP). Which is exactly what
> > Ron
> > told you.
> >
> > The ALS() got translated to IF()
> > the AFRONDEN.N.VEELVOUD() did NOT translate to MROUND()
> >
> > This is a known Excel shortcoming.
> >
> > Solutions:
> > ==========
> > 1. Have a name (Ctrl-F3) defining the langage (Lang="Dt" or "Eg" or
> > whatever) and have your formulas containing ATP functions wrapped-written
> > like
> > this : IF(Lang="Dt", dutch_formula, english_formula)
> > In this scenario, the name has to be set on the Workbook_Open event
> > using Application.International(xlCountryCode) result
> >
> > 2. Use http://www.acoustics-noise.com/ATPtranslator.shtml
> >
> > 3. Bypass ATP functions (either by using other 'normal' functions or VBA
> > code)
> > For instance, MROUND(A1,A2) can be replaced by =ROUND(A1/A2,)*A2
> >
> > Regards,
> >
> > Daniel M.
> >
> > "MMS USA" <MMS [email protected]> wrote in message
> > news:[email protected]...
> >> Well, I would have to say they don't. Otherwise this would not be a
> >> problem.
> >>
> >> Is anyone else seeing this issue?
> >>
> >> "Ron de Bruin" wrote:
> >>
> >> > Hi
> >> >
> >> > All normal Excel functions will translate(also in 2003)
> >> > Only the ATP Add-in functions not.
> >> >
> >> > For a file with translations see (FuncRefXLv4-0 from Norman Harker)
> >> > http://www.contextures.com/functions.html
> >> >
> >> >
> >> > --
> >> > Regards Ron de Bruin
> >> > http://www.rondebruin.nl
> >> >
> >> >
> >> >
> >> > "MMS USA" <MMS [email protected]> wrote in message
> >> > news:[email protected]...
> >> > > Thank you, but this information is too sensitive to send. As you can
> >> > > see,
> >> > > If
> >> > > is already used in the equations, not Als. These are Dutch words for
> >> > > things
> >> > > like sum, etc. that the US version is not recognzing.
> >> > >
> >> > > I'm looking to understand what makes 2002 read these equations and
> >> > > 2003
> >> > > not.
> >> > >
> >> > > Are there language updates that may not be in the 2003 install?
> >> > >
> >> > > "Ron de Bruin" wrote:
> >> > >
> >> > >> Hi MMS USA
> >> > >>
> >> > >> If = Als in Dutch
> >> > >> You can send me the file private and I will test it for you
> >> > >>
> >> > >>
> >> > >>
> >> > >> --
> >> > >> Regards Ron de Bruin
> >> > >> http://www.rondebruin.nl
> >> > >>
> >> > >>
> >> > >>
> >> > >> "MMS USA" <MMS [email protected]> wrote in message
> >> > >> news:[email protected]...
> >> > >> > I've recently upgraded from the previous USA Office XP 2002 to USA
> >> > >> > Office
> >> > >> > XP
> >> > >> > 2003.
> >> > >> >
> >> > >> > In office XP 2002 I was able to use our company's excel file that
> >> > >> > comes
> >> > >> > from
> >> > >> > Holland. All the equations in the excel file are written in
> >> > >> > Dutch.
> >> > >> > Here's
> >> > >> > an example:
> >> > >> >
> >> > >> >
> > =IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.
> > N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<
> > 20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),
> > "")
> >> > >> >
> >> > >> > Now, in Office XP 2003 the contents of this equation produces
> >> > >> > #NAME?.
> >> > >> > I
> >> > >> > can't seem to find any type of language setting or addon package
> >> > >> > that
> >> > >> > corrects this. Nor can I seem to find out what language changes
> >> > >> > have
> >> > >> > been
> >> > >> > made between the two versions.
> >> > >> >
> >> > >> > I've had multiple different installations of XP 2002 on different
> >> > >> > computers
> >> > >> > all able to "translate" these equations so that tells me it wasn't
> >> > >> > unique
> >> > >> > to
> >> > >> > just 1 install. How do I get XP 2003 to recognize these
> >> > >> > equations?
> >> > >> >
> >> > >> > Any help would be greatly appreciated.
> >> > >> >
> >> > >>
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
> >
> >
>
>
>

Oh, another thing, Ron. The old Excel 2002 didn't "translate" the word. It
took the Dutch words and executed the equation.

"Ron de Bruin" wrote:

> Hi Daniel
>
> I like to have his old Excel 2002 version that do the translations<vbg>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Daniel.M" <[email protected]> wrote in message
> news:[email protected]...
> >
> > Well, I would say the only functions that did NOT translate in your
> > formula were
> > the ones belonging to the Analysis Toolpak (ATP). Which is exactly what
> > Ron
> > told you.
> >
> > The ALS() got translated to IF()
> > the AFRONDEN.N.VEELVOUD() did NOT translate to MROUND()
> >
> > This is a known Excel shortcoming.
> >
> > Solutions:
> > ==========
> > 1. Have a name (Ctrl-F3) defining the langage (Lang="Dt" or "Eg" or
> > whatever) and have your formulas containing ATP functions wrapped-written
> > like
> > this : IF(Lang="Dt", dutch_formula, english_formula)
> > In this scenario, the name has to be set on the Workbook_Open event
> > using Application.International(xlCountryCode) result
> >
> > 2. Use http://www.acoustics-noise.com/ATPtranslator.shtml
> >
> > 3. Bypass ATP functions (either by using other 'normal' functions or VBA
> > code)
> > For instance, MROUND(A1,A2) can be replaced by =ROUND(A1/A2,)*A2
> >
> > Regards,
> >
> > Daniel M.
> >
> > "MMS USA" <MMS [email protected]> wrote in message
> > news:[email protected]...
> >> Well, I would have to say they don't. Otherwise this would not be a
> >> problem.
> >>
> >> Is anyone else seeing this issue?
> >>
> >> "Ron de Bruin" wrote:
> >>
> >> > Hi
> >> >
> >> > All normal Excel functions will translate(also in 2003)
> >> > Only the ATP Add-in functions not.
> >> >
> >> > For a file with translations see (FuncRefXLv4-0 from Norman Harker)
> >> > http://www.contextures.com/functions.html
> >> >
> >> >
> >> > --
> >> > Regards Ron de Bruin
> >> > http://www.rondebruin.nl
> >> >
> >> >
> >> >
> >> > "MMS USA" <MMS [email protected]> wrote in message
> >> > news:[email protected]...
> >> > > Thank you, but this information is too sensitive to send. As you can
> >> > > see,
> >> > > If
> >> > > is already used in the equations, not Als. These are Dutch words for
> >> > > things
> >> > > like sum, etc. that the US version is not recognzing.
> >> > >
> >> > > I'm looking to understand what makes 2002 read these equations and
> >> > > 2003
> >> > > not.
> >> > >
> >> > > Are there language updates that may not be in the 2003 install?
> >> > >
> >> > > "Ron de Bruin" wrote:
> >> > >
> >> > >> Hi MMS USA
> >> > >>
> >> > >> If = Als in Dutch
> >> > >> You can send me the file private and I will test it for you
> >> > >>
> >> > >>
> >> > >>
> >> > >> --
> >> > >> Regards Ron de Bruin
> >> > >> http://www.rondebruin.nl
> >> > >>
> >> > >>
> >> > >>
> >> > >> "MMS USA" <MMS [email protected]> wrote in message
> >> > >> news:[email protected]...
> >> > >> > I've recently upgraded from the previous USA Office XP 2002 to USA
> >> > >> > Office
> >> > >> > XP
> >> > >> > 2003.
> >> > >> >
> >> > >> > In office XP 2002 I was able to use our company's excel file that
> >> > >> > comes
> >> > >> > from
> >> > >> > Holland. All the equations in the excel file are written in
> >> > >> > Dutch.
> >> > >> > Here's
> >> > >> > an example:
> >> > >> >
> >> > >> >
> > =IF(+G21<>"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+0.49,1),IF(+G21<1000,AFRONDEN.
> > N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10),IF(+G21<
> > 20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),
> > "")
> >> > >> >
> >> > >> > Now, in Office XP 2003 the contents of this equation produces
> >> > >> > #NAME?.
> >> > >> > I
> >> > >> > can't seem to find any type of language setting or addon package
> >> > >> > that
> >> > >> > corrects this. Nor can I seem to find out what language changes
> >> > >> > have
> >> > >> > been
> >> > >> > made between the two versions.
> >> > >> >
> >> > >> > I've had multiple different installations of XP 2002 on different
> >> > >> > computers
> >> > >> > all able to "translate" these equations so that tells me it wasn't
> >> > >> > unique
> >> > >> > to
> >> > >> > just 1 install. How do I get XP 2003 to recognize these
> >> > >> > equations?
> >> > >> >
> >> > >> > Any help would be greatly appreciated.
> >> > >> >
> >> > >>
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
> >
> >
>
>
>

Hi,


> Thanks Daniel and Ron, however, Daniel, the link for the prog on the page you
> offered seems to bring me to a forbidden area. Can't get the Analysis
> ToolPack translator 7.0.

You're right: there's a problem on the site.
I guess it's only temporary 'cause I've downloaded the utility before.
You can contact the author (search for Eric Desart on the site) to advise him.


> HOWEVER, I did perform a replace all on AFRONDEN.N.VEELVOUD and changed them
> to ROUND and it worked.

Glad to see you've worked it out.

Regards,

Daniel M.

Daniel and others,

I'm really sorry,
But my site is hacked 5 times in 6 weeks.
The last one is very serious.
I can't access my own site anymore.

More here:
http://forum.studiotips.com/viewtopic.php?t=1287

This is not a commercial site, but just hobby.
And I can't find the time and energy to find a more permanent solution.

I can't keep busy restoring my site.
The 4 first times it was relative easy, the last time a disaster.

I had an average of 50 downloads a day.
Lots of those people write me.
I just don't have the time to send all those documents to all
inquiries.

Since this Analysis ToolPak Translator is downloaded > 5300 times,
there must be lots of them going around.

You help me and others, when you email a copy of your own to the ones
wanting to use it.

I have no idea when this will be solved now.
I really am sorry and hope you forgive me.

This is all freeware and educational files.
One shout shoot (matter of speech) the moron doing such idiotic things.
This cost me that much time already, I get really frustrated.

With warm regards
Eric


Daniel.M wrote:
> Hi,
>
>
> > Thanks Daniel and Ron, however, Daniel, the link for the prog on
the page you
> > offered seems to bring me to a forbidden area. Can't get the
Analysis
> > ToolPack translator 7.0.
>
> You're right: there's a problem on the site.
> I guess it's only temporary 'cause I've downloaded the utility
before.
> You can contact the author (search for Eric Desart on the site) to
advise him.
>
>
> > HOWEVER, I did perform a replace all on AFRONDEN.N.VEELVOUD and
changed them
> > to ROUND and it worked.
>
> Glad to see you've worked it out.
>
> Regards,
>
> Daniel M.