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:
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, 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:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
Additional query words: XL97 toolpack
Keywords: kbdownload kbbug kberrmsg kbfix kbprogramming KB165134