Microsoft KB Archive/291058

= Analysis ToolPak functions unexpectedly return #NAME error value in Excel 2003 and in Excel 2002 =

Article ID: 291058

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q291058



For a Microsoft Excel 2000 version of this article, see 182190.

For a Microsoft Excel 98 version of this article, see 192363.

For a Microsoft Excel 97 and earlier version of this article, see 121730.



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 Paste Function dialog box.



CAUSE
The Analysis ToolPak is not always automatically loaded when you start Microsoft Excel.



RESOLUTION
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:
 * 1) Select a cell that contains the error.
 * 2) 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:
 * 1) On the Edit menu, click Replace.
 * 2) Type = in the Find what box.
 * 3) Type = in the Replace with box.
 * 4) Click Replace All.

Method 3: Force Formula Updating by Using Keyboard Shortcut
You can also press CTRL+ALT+SHIFT+F9 to force all formulas to update.

NOTE: This method forces all formulas in the active worksheet and dependent formulas in other worksheets to recalculate.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



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

Additional query words: Atp tool pack toolpack tools pak XL2002 XL2003

Keywords: kbbug kberrmsg kbpending KB291058

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.