XL97: Analysis ToolPak Functions Return #VALUE!
ID: Q165134
|
The information in this article applies to:
-
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, 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:
Q176476
OFF: Office Assistant Not Answering Visual Basic Questions
Additional query words:
XL97 toolpack
Keywords : kberrmsg kbprg kbdta KbVBA
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug