Microsoft KB Archive/248174

= XL2000: Formulas Calculate Incorrectly After Changing Worksheet Name =

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

-

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

© Microsoft Corporation. All rights reserved.