XL: Some Functions Unexpectedly Return #NAME Error Value

ID: Q121730

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows
Microsoft Excel for the Macintosh, version 5.0

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 select the Analysis ToolPak check box or the Analysis ToolPak - VBA check box.

Note that for the change to take effect, you may need to select the formulas in the cells that contain the #NAME error, and recalculate the worksheet (to do this, press F9).

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.

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

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, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q120802
   TITLE     : 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.00 5.00a 5.00c 7.00 97 Atp tool pack toolpack tools pak

Keywords          : kbdta xlformula xladdins 
Version           : WINDOWS:5.0,5.0c,7.0,7.0a,97; MACINTOSH:5.00
Platform          : MACINTOSH WINDOWS
Issue type        : kbprb

Last Reviewed: January 8, 1999