#1   Report Post  
Jim Rech
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
symbol for divison problems; divison formula excel general question ... help please Excel Discussion (Misc queries) 4 July 15th 06 05:24 PM
Problems with Excel 2003 after downloading Office SP1 Kristy Excel Discussion (Misc queries) 0 February 22nd 05 06:13 PM
Dynamic charting problems (events) [email protected] Charts and Charting in Excel 4 January 27th 05 09:32 PM
"Problems during load" Vincent Excel Discussion (Misc queries) 1 January 19th 05 08:38 PM
Problems pasting images into Excel Wazooli Excel Discussion (Misc queries) 2 December 7th 04 11:33 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"