compatibility of Excel 03 with Excel 02?

[Natano]

I have excel PE 03, and I'm trying to import a spreadsheet developed in excel
02. The equations are not working, in particular, I get an "invalid name"
error in the cels that reference other cels within the same worksheet. The
cel with the error uses the "mround" equation on the referenced cel.

An office mate gave me the file and is using it successfully on his machine,
which is the 02 version of excel.

Is this a compatibility issue? If so, what is the fix?

thanks,

Nathan

 

[JulieD]

Hi

it's not a problem between 2002 / 2003 ... the MROUND function is part of
the analysis toolpak add-in ..
-------extract from help
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

 

[Duke Carey]

Go to Tools>Add-ins and check the Analysis Toolpak

Once loaded, you'll be able to use the MROUND() function

 

[Gord Dibben]

Natano

Not a compatibility issue.

MROUND is a Function from the Analysis ToolPak.

Load it through Tools>Add-ins.


Gord Dibben Excel MVP