could the #NAME? error be a compatibility issue?

[sweetsourpork]

I have a computer with excel '07 and a computer with excel '03.
When I view the .xls document in '07, then all the formulas work fine.
When I view the .xls document in '03 then several of the formulas display
the #NAME? error. halp plz.

 

[Peo Sjoblom]

Look up Analysis ToolPak in help on the pc with 2003 installed,
my guess is that you need to install it on the 2003. I believe it gets
installed default
on 2007 but on 2003 you need to manually install it. Just click
tools>add-ins,
select Analysis ToolPak and follow the instructions. Note that you need to
CD unless
it is installed already


--


Regards,


Peo Sjoblom

 

[sweetsourpork]

The errors are gone now. Thank you so much!

Look up Analysis ToolPak in help on the pc with 2003 installed,
my guess is that you need to install it on the 2003. I believe it gets
installed default
on 2007 but on 2003 you need to manually install it. Just click
tools>add-ins,
select Analysis ToolPak and follow the instructions. Note that you need to
CD unless
it is installed already


--


Regards,


Peo Sjoblom