XL97: Worksheet Displays Incorrect Values After Calculation

Last reviewed: February 27, 1998
Article ID: Q171726
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When values in a workbook are calculated, incorrect values may appear in the active worksheet.

CAUSE

This problem may occur when the following conditions are true:

  • One or more cells in an open workbook call a user-defined function.

        -and-
    
  • The user-defined function uses a built-in Microsoft Excel worksheet function.

RESOLUTION

To correct this problem, install Microsoft Excel 97 Service Release 1 (SR-1).

To work around this problem, scroll down the worksheet so the cells that display incorrect values no longer appear on the screen. Scrolling forces Excel to redraw the screen, which causes the correct values to be displayed on the active worksheet.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Excel 97 SR-1.

For additional information about SR-1, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q172475
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-1

REFERENCES

For more information about calculating formulas, click the Index tab in Microsoft Excel Help, type the following text

   calculation, formulas

and then double-click the selected text to go to the "Create a formula to calculate data on another worksheet or workbook" topic.


Additional query words: XL97 sr1
Keywords : kbprg
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug
Solution Type : kbfix


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 27, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.