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