Article ID: 121730
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q121730
For a Microsoft Excel 2002 version of this article, see 291058.
For a Microsoft Excel 2000 version of this article, see 182190.
For a Microsoft Excel 98 version of this article, see 192363.
SYMPTOMS
In Microsoft Excel, you may experience the following problems when you use a worksheet function that is included in the Analysis ToolPak add-in:
- You receive the #NAME error value.
-or-
- The function you want to use is not available in the Function Wizard.
CAUSE
The Analysis ToolPak is not always automatically loaded when you start Microsoft Excel.
WORKAROUND
To work around this problem, click Add-Ins on the Tools menu, and click to select the Analysis ToolPak check box or the Analysis ToolPak - VBA check box.
If the Analysis ToolPak is not available in the Add-Ins dialog box, you may need to run the Setup program and reinstall the add-ins.
Note that for the change to take effect, you need to update each formula that references the add-in. To do this, use either of the following methods.
Method 1: Force Individual Formulas to Update
To force an individual formula to update, follow these steps:
- Select a cell that contains the error.
- Press F2, and then press ENTER.
Repeat these steps for any other formulas that have not been updated.
Method 2: Force Formula Updating by Replacing Equal Signs
To force all formulas to update, follow these steps:
- On the Edit menu, click Replace.
- Type = in the Find what box.
- Type = in the Replace with box.
- Click Replace All.
NOTE: This forces all formulas in the active worksheet and dependent formulas in other worksheets to recalculate.
MORE INFORMATION
The worksheet functions that are loaded as part of the Analysis ToolPak include the following:
ACCRINT DEC2BIN HEX2OCT ISEVEN SERIESSUM ACCRINTM DEC2HEX IMABS ISODD SQRTPI BESSELI DEC2OCT IMAGINARY LCM TBILLEQ BESSELJ DELTA IMARGUMENT MDURATION TBILLPRICE BESSELK DISC IMCONJUGATE MROUND TBILLYIELD BESSELY DOLLARDE IMCOS MULTINOMIAL WEEKNUM BIN2DEC DOLLARFR IMDIV NETWORKDAYS WORKDAY BIN2HEX DURATION IMEXP NOMINAL XIRR BIN2OCT EDATE IMLN OCT2BIN XNPV COMPLEX EFFECT IMLOG10 OCT2DEC YEARFRAC CONVERT EOMONTH IMLOG2 OCT2HEX YIELD COUPDAYBS ERF IMPOWER ODDFPRICE YIELDDISC COUPDAYS ERFC IMPRODUCT ODDFYIELD YIELDMAT COUPDAYSNC FACTDOUBLE IMREAL ODDLPRICE COUPNCD FVSCHEDULE IMSIN ODDLYIELD COUPNUM GCD IMSQRT PRICE COUPPCD GESTEP IMSUB PRICEDISC CUMIPMT HEX2BIN IMSUM PRICEMAT CUMPRINC HEX2DEC INTRATE RECEIVED
REFERENCES
Excel 97
For more information about installing the Analysis ToolPak, click the Office Assistant, type install analysis toolpak, click Search, and then click to view "Install and use the Analysis ToolPak."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, click the article number below to view the article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
Excel 5.0
For more information about the Analysis ToolPak, click the Search button in Help and type:
Analysis ToolPak, installation
Additional query words: 5.00a 5.00c 97 Atp tool pack toolpack tools pak XL
Keywords: kbprb KB121730