| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
XIRR function not defined?
For some reason the XIRR function on the version of Excel 2003 on my new
computer is not working. When I enter it the "#NAME?" response comes up, and when I go into the function using "fx" it says that it is "undefined." What is going on here and how can I fix this? Thanks, Alex |
|
#2
|
|||
|
|||
|
This function is part of the analysis toolpak addin.
You have to install it (if it's not installed) and turn it on. If you look under Tools|Addins, do you see Analysis Toolpak in the list? If you do, just check it. If you don't see it there, close excel and use your distribution CD to install that addin. Alex wrote: For some reason the XIRR function on the version of Excel 2003 on my new computer is not working. When I enter it the "#NAME?" response comes up, and when I go into the function using "fx" it says that it is "undefined." What is going on here and how can I fix this? Thanks, Alex -- Dave Peterson |
|
#3
|
|||
|
|||
|
Beautiful. Thanks!
Alex "Dave Peterson" wrote: This function is part of the analysis toolpak addin. You have to install it (if it's not installed) and turn it on. If you look under Tools|Addins, do you see Analysis Toolpak in the list? If you do, just check it. If you don't see it there, close excel and use your distribution CD to install that addin. Alex wrote: For some reason the XIRR function on the version of Excel 2003 on my new computer is not working. When I enter it the "#NAME?" response comes up, and when I go into the function using "fx" it says that it is "undefined." What is going on here and how can I fix this? Thanks, Alex -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
XIRR function not defined?
"Dave Peterson" wrote: This function is part of the analysis toolpak addin. You have to install it (if it's not installed) and turn it on. If you look under Tools|Addins, do you see Analysis Toolpak in the list? If you do, just check it. If you don't see it there, close excel and use your distribution CD to install that addin. Alex wrote: For some reason the XIRR function on the version of Excel 2003 on my new computer is not working. When I enter it the "#NAME?" response comes up, and when I go into the function using "fx" it says that it is "undefined." What is going on here and how can I fix this? Thanks, Alex -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Attaching Help File to a User Defined Function | Excel Discussion (Misc queries) | |||
| XIRR function input parameters | Excel Worksheet Functions | |||
| Attaching a particular user defined function to cust button | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| how to move user defined function | Excel Worksheet Functions | |||
Hybrid Mode
