Microsoft KB Archive/253819

= XL2000: Recalculation of UDFs and XLLs Gives Unexpected Results That Depend on Sheet Names =

Article ID: 253819

Article Last Modified on 11/23/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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)



STATUS
Microsoft 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.

Additional query words: excel 2000 excel2K xl2000 xl2K calculated rename worksheet incorrect

Keywords: kbbug kbdtacode kbfix kbqfe KB253819

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.