Microsoft KB Archive/248174
Article ID: 248174
Article Last Modified on 9/23/2005
- Microsoft Excel 2000 Standard Edition
This article was previously published under Q248174
When you recalculate your worksheet, some formulas may calculate incorrect values.
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.
- Your workbook uses one or more custom functions that are stored in an XLL file.
- You rename one or more of your worksheets so that the alphabetic sort order of the worksheets change.
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)
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