Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
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
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 May 10 '10 at 15:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .