XL98: Formula Is Not Recalculated After Paste Special Operation (184261)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q184261 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.
WORKAROUND
To work around this problem, follow these steps:
- On the Edit menu, click Replace.
- In the Find What box, type =. In the
Replace With box, type =. Click Replace
All.
The formulas are recalculated correctly after the "=" is replaced in the
cells.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbbug KB184261 |
---|
|