![]() |
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. |
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. |
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