Microsoft KB Archive/165134

= XL97: Analysis ToolPak Functions Return #VALUE! =

Article ID: 165134

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q165134



SYMPTOMS
When you enter or edit a formula that contains a function provided by the Analysis ToolPak add-in, the formula may return a #VALUE! error.



CAUSE
This problem may occur when you create a reference to Atpvbaen.xla in a Visual Basic for Applications module sheet.

If you remove the reference to Atpvbaen.xla, when you enter or edit a formula that contains a function provided by the Analysis ToolPak add-in, the formula returns the #NAME? error.

NOTE: If you do not edit an existing formula containing an Analysis ToolPak function after establishing a reference to Atpvbaen.xla, Microsoft Excel calculates the formula as expected.

RESOLUTION
To resolve this issue, install the Excel 97 Service Release 1 (SR-1): Auto-Recalculation Patch.

To obtain the Excel 97 Service Release 1: Auto-Recalculation Patch, visit the following Microsoft Web site:

http://office.microsoft.com/downloads/9798/xl8patch.aspx



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Excel 97 for Windows, Service Release 1 (SR-1).



MORE INFORMATION
The problem may occur with the following worksheet functions:   AMORDEGRC    FACTDOUBLE    NETWORKDAYS AMORLINC    FVSCHEDULE    NOMINAL BESSELI     GCD           OCT2BIN BESSELJ     GESTEP        OCT2DEC BESSELK     HEX2BIN       OCT2HEX BESSELY     HEX2DEC       ODDFPRICE BIN2DEC     HEX2OCT       ODDFYIELD BIN2HEX     IMABS         ODDLPRICE BIN2OCT     IMAGINARY     ODDLYIELD COMPLEX     IMARGUMENT    PRICE CONVERT     IMCONJUGATE   PRICEDISC COUPDAYS    IMCOS         PRICEMAT COUPDAYBS   IMDIV         QUOTIENT COUPDAYSNC  IMEXP         RANDBETWEEN COUPNCD     IMLN          RECEIVED COUPNUM     IMLOG10       SERIESSUM COUPPCD     IMLOG2        SQRTPI CUMIPMT     IMPOWER       TBILLEQ CUMPRINC    IMPRODUCT     TBILLPRICE DEC2BIN     IMREAL        TBILLYIELD DEC2HEX     IMSIN         WEEKNUM DEC2OCT     IMSQRT        WORKDAY DELTA       IMSUB         XIRR DISC        IMSUM         XNPV DOLLARDE    INTRATE       YEARFRAC DOLLARFR    ISEVEN        YIELD DURATION    ISODD         YIELDDISC EDATE       ISSHARED      YIELDMAT EFFECT      LCM EOMONTH     MDURATION

