up vote 1 down vote favorite
share [g+] share [fb]

I am trying to price bonds using the Excel function, PRICE(..), but the intellisense doesn't come up. The help file says to install the analysis tool pack, but this doesn't resolve the problem. I have Office 2003 for XP.

thanks!

link|improve this question
100% accept rate
feedback

1 Answer

up vote 1 down vote accepted

If you're trying to use it in a worksheet function, go to Tools - Addins and select Analysis Toolpak. Make sure there's a checkbox next to it before you click OK. You can't just select it (highlight), you have to click the box (green check).

If you're trying to use it in VBA, there's a separate add-in called Analysis Tookpak - VBA. Make sure that's checked to use it in code.

link|improve this answer
Thanks, but that's just the problem - the analysis toolpak is installed, and works for other functions like FV. – Kaiser Advisor May 8 '10 at 14:46
1  
That stinks. PRICE worked in mine. I wonder if your add-in file is corrupted. It might be worth a shot to replace it. I can email you a copy if you want to try it. dkusleika@gmail.com – dkusleika May 10 '10 at 15:58
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.