Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
So if you edit one of these introduced paths to become just =YEARFRAC does
the formula then work? If so perhaps a Find/Replace of the full path\function name with just the function name will fix the problem. I must confess I have used the Analysis Toolpak very little. -- Jim "Adriana" wrote in message ... |I have Excel 2002 in spanish. I created a system that calculates the interest | service from varios kind of debt from a Company. It requires to use the | yearfrac function to calculate how many days between each payment are to be | taken into account for the calculation of interest, given the diversity in | the types of bonds that this company issued. | | The system requires to open for example 3 BIG!!! workbooks at the same time | (stock, cupons and proyected service) stock and cupon feed proyected service, | so they are linked. The function yearfrac is used in the workbook "cupons". | | I have activated the add-ins required to use yearfrac. However when I open | the 3 workbooks I find that every place where I used the function yearfrac in | the woorkbook cupons the system substituted it for another name using the | path of the program ATPVBAEN.XLA , and aditionally it introduced the latter | as an external link!!!!! which I did no create. | | After that the workbook "cupons" give me the error #Value where it is | suppose to calculate yearfrac!!!!. | | Could somebody please help me and tell me how to correct it and why it | happen!!!!! | | Thanks a lot!!! | | Adriana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
symbol for divison problems; divison formula | Excel Discussion (Misc queries) | |||
Problems with Excel 2003 after downloading Office SP1 | Excel Discussion (Misc queries) | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
"Problems during load" | Excel Discussion (Misc queries) | |||
Problems pasting images into Excel | Excel Discussion (Misc queries) |