Article ID: 248174
Article Last Modified on 9/23/2005
APPLIES TO
- Microsoft Excel 2000 Standard Edition
This article was previously published under Q248174
SYMPTOMS
When you recalculate your worksheet, some formulas may calculate incorrect values.
CAUSE
This problem may occur when the following conditions are true:
- Your workbook uses one or more custom functions that are written in Microsoft Visual Basic for Applications.
-and-
- Your workbook uses one or more custom functions that are stored in an XLL file.
-and-
- You rename one or more of your worksheets so that the alphabetic sort order of the worksheets change.
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: XL2000 udf recalc user-defined
Keywords: kbbug kbfix kbqfe kbhotfixserver KB248174
