XL2000: Formulas Calculate Incorrectly After Changing Worksheet Name (248174)
The information in this article applies to:
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)
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: | 9/23/2005 |
---|
Keywords: | kbHotfixServer kbQFE kbbug kbfix KB248174 |
---|
|