Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Analysis ToolPak Functions Unexpectedly Return #NAME Error Value

XL2000: Analysis ToolPak Functions Unexpectedly Return #NAME Error Value

View products that this article applies to.

This article was previously published under Q182190
For a Microsoft Excel 2002 version of this article, see 291058� (http://support.microsoft.com/kb/291058/EN-US/ ) .
For a Microsoft Excel 98 version of this article, see 192363� (http://support.microsoft.com/kb/192363/EN-US/ ) .
For a Microsoft Excel 97 and earlier version of this article, see 121730� (http://support.microsoft.com/kb/121730/EN-US/ ) .

↑ Back to the top

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.

↑ Back to the top

Cause

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

↑ Back to the top

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.
NOTE: This forces all formulas in the active worksheet and dependent formulas in other worksheets to recalculate.

↑ Back to the top

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

↑ Back to the top

Keywords: KB182190, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 182190
Revision : 3
Created on : 10/6/2003
Published on : 10/6/2003
Exists online : False
Views : 343