| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Issue writing IF OR Error Formula Types | New Users to Excel | |||
| Compatibility | Excel Discussion (Misc queries) | |||
| Macro Issue - Run time error 1004 | Excel Discussion (Misc queries) | |||
| Sumproduct #N/A! error issue | Excel Worksheet Functions | |||
| Date compatibility error | Excel Discussion (Misc queries) | |||
Hybrid Mode
