ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   could the #NAME? error be a compatibility issue? (https://www.excelbanter.com/new-users-excel/167167-could-name-error-compatibility-issue.html)

sweetsourpork

could the #NAME? error be a compatibility issue?
 
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

could the #NAME? error be a compatibility issue?
 
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
toolsadd-ins,
select Analysis ToolPak and follow the instructions. Note that you need to
CD unless
it is installed already


--


Regards,


Peo Sjoblom


"sweetsourpork" wrote in message
...
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.




sweetsourpork

could the #NAME? error be a compatibility issue?
 
The errors are gone now. Thank you so much!

"Peo Sjoblom" wrote:

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
toolsadd-ins,
select Analysis ToolPak and follow the instructions. Note that you need to
CD unless
it is installed already


--


Regards,


Peo Sjoblom


"sweetsourpork" wrote in message
...
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.






All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com