I live in London, and I'm working on a english version of Excel and
VBA..
I've just finished a massive workbook for my mother with standard
english formulas, but it isn't recognised by her norwegian version on
Excel and VBA.

How can I convert this... is there a function library I can add to her
version, so she can use my spreadsheets and macros?

I have found one converter on the net, but it doesn't seem to work
properly.

Help would be much apprichiated,
Thanks


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=514363

Excel should automatically convert those formulae when the workbook is
opened in a Norwegian version.

The exception is Analysis Toolpak functions, such as WEEKNUM, MROUND, etc.,
which don't translate automatically. It is best to rewrite these as non-ATP
formulae. If you post your ATP formulae, we should be able to help you
rewrite them.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ctech" wrote in
message ...

I live in London, and I'm working on a english version of Excel and
VBA..
I've just finished a massive workbook for my mother with standard
english formulas, but it isn't recognised by her norwegian version on
Excel and VBA.

How can I convert this... is there a function library I can add to her
version, so she can use my spreadsheets and macros?

I have found one converter on the net, but it doesn't seem to work
properly.

Help would be much apprichiated,
Thanks


--
Ctech


------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=514363

I would expect Excel to automatically convert the function/formualas
too... however it does that seem to do this.

Is there an option in Excel which can turn this on/off?

I have Office XP on both the computers?


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=514363

I don't think so.

Give an example of an English function that doesn't translate in the
Norwegian Excel.

BTW, VBA works in English, regardless of the VBA version.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ctech" wrote in
message ...

I would expect Excel to automatically convert the function/formualas
too... however it does that seem to do this.

Is there an option in Excel which can turn this on/off?

I have Office XP on both the computers?


--
Ctech


------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=514363

Non of the formulas I use gets converted..

Here is some examples:


ISNUMBER
SUMIF
IF
AVERAGE
SUMPRODUCT

i.e.

=SUMPRODUCT(--(Inntekter!$B$5:$B$203=$B197),
--(TEXT(Inntekter!$A$5:$A$203,"yyyymm")=""&K$9&""),
--(Inntekter!$C$5:$C$203=$B$193),
(Inntekter!$E$5:$E$203))


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=514363

So If I opens a excel document with norwegian formulas on my PC, should
it thenautomatically update when I open it for the first time?


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=514363