XL2000: Recalculation of UDFs and XLLs Gives Unexpected Results That Depend on Sheet Names (253819)
The information in this article applies to:
This article was previously published under Q253819 SYMPTOMS
When you use custom functions (UDFs) inside stand-alone dynamic-link libraries (XLLs), together with Microsoft Visual Basic for Applications custom functions, Excel may produce incorrect values.
CAUSE
This problem may occur depending on the sort order of sheet names in the workbook.
RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).
To obtain SR-1/SR-1a, click the
article number below to view the article in the Microsoft Knowledge Base:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbbug kbdtacode kbfix kbQFE KB253819 |
|---|
|