Yearfrac problems

[Guest]

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

 

[Jim Rech]

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
|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