Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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!

share|improve this question

1 Answer 1

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.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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