XL97: Formula Is Not Recalculated After Paste Special Operation (184260)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q184260 SYMPTOMS
When you copy values and perform a Paste Special operation, formulas that
refer to the pasted values may not be automatically recalculated.
CAUSE
This problem occurs if the following conditions are true:
- You copy values on a worksheet.
-and-
- You click Values in the Paste Special dialog box.
-and-
- You click Skip Blanks in the Paste Special dialog box.
-and-
- The formula is in the destination range of the pasted values.
-and-
- The formula is an array formula.
RESOLUTION
To prevent this problem, obtain and install Microsoft Office 97,
Service Release 2 (SR-2).
For additional information about SR-2, please see the following article
in the Microsoft Knowledge Base:
151261
OFF97: How to Obtain and Install MS Office 97 SR-2
STATUS
Microsoft has confirmed this to be a problem in the Microsoft Excel 97
for Windows. This problem was corrected in Microsoft Excel 97 for Windows,
Service Release 2 (SR-2).
Modification Type: | Major | Last Reviewed: | 10/22/2000 |
---|
Keywords: | kbbug KB184260 |
---|
|