XL97: Analysis ToolPak Functions Return #VALUE!

• Microsoft Excel 97 for Windows

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.

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

REFERENCES

For more information about using References, click the Office Assistant while in the Visual Basic Editor, type "adding references" (without the quotation marks), click Search, and then click to view the "References Command (Tools Menu)" topic.

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q176476
   TITLE     : OFF: Office Assistant Not Answering Visual Basic Questions