XL97: Worksheet Displays Incorrect Values After Calculation (171726)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q171726 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:
172475 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
and then double-click the selected text to go to the "Create a formula to
calculate data on another worksheet or workbook" topic.
| Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
|---|
| Keywords: | kbbug kbfix kbProgramming KB171726 |
|---|
|