Microsoft KB Archive/248174

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:14, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

XL2000: Formulas Calculate Incorrectly After Changing Worksheet Name

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