2000 vs 97 Formulae

[Phani]

I am using Microsoft Office 2000 on my computer, but I
have a spread sheet which was designed in Office 97. This
spreadsheet works fine without any errors in 97
environment but when I try to use the same spread sheet in
Office 2000, it comes up with a bunch of "!VALUE" as the
contents of the cell. I am trying to understand why this
is happening. I have a large amount of cells with various
formulae in them.

My questions to you would be:

a. Is there a reason why this is happening?

b. If so, what would that be?

c. Also, Have the formulae changed so much
between Office 2K and Office 97 that they are no longer
compatible with each other?

d. Is there a simple way of finding and fixing
all these formulae w/o sitting and going thru each and
every formulae to try and see if they have been changed or
not. The issue that makes the trace back worse is that the
trace leads to a tree with each branch having a couple of
subbranch of formulae.

 

[John Wilson]

Phani,

The formulas (almost all, at least) should be compatible.
What formulas are giving you the errors?
Maybe you're using formulas from the Analysis Toolpack
and it's not loaded on both PC's??

John

 

[phani]

Sorry about the confusion...

The original spreadsheet was created in a German version
of Excel 95. It still works in the German version of
Excel 2000. It's when the spreadsheet is opened in an
English version that the problems arise.

We've narrowed down one particular function that is used,
but it may not be the only function.

The spreadsheet uses the "Cell" function. In the
formula "cell(info_type/reference), the German version
uses "typ" for the info_type, the English version
uses "type." Changing the typ to type only helps part of
the problem.

In the spreadsheet one cell links to another, which links
to another, and so on for what seems to be a infinite
number of links. Narrowing down other functions will take
some time.

Finally, yes the analysis toolpack is installed on the
English machine.

 

[Niek Otten]

All functions which accept literals as arguments, like Text, Date, Indirect,
etc, cause problems when changing language. I haven't found a way around
yet. Of course it would have been better if Excel asked for defined
constants, like in VBA. But it just isn't that way.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Phani]

I just found out from our client that this works in
English version of Excel 95.

 

[Norman Harker]

Hi phani!

Eric Desart has a translator that may help:

http://www.acoustics-noise.com/

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.