Microsoft KB Archive/184260

= XL97: Formula Is Not Recalculated After Paste Special Operation =

Article ID: 184260

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



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).



Example
To see an example of the problem described in the "Symptoms" section of this article, follow these steps:

 Create a new workbook.  Type the following values in Sheet1:      A1: a   B1: 1  C1: 10 A2: b  B2: 2  C2: 20 A3:    B3:    C3: A4: a  B4: 1  C4: 10 A5: b  B5: 2  C5: 20   Type the following formula in cell B7:

=SUM(IF(A1:A5="a",B1:B5)) NOTE: Note that you must enter this formula as an array formula. To do this, type the formula in the formula bar, and then press CTRL+SHIFT+ENTER to enter the formula.

The formula returns a value of 2.  Select cells C1:C8, and then click Copy on the Edit menu.</li> Select cell B1.</li> Click Paste Special on the Edit menu.</li> In the Paste Special dialog box, click Values under Paste, and click Skip Blanks. Click OK.</li></ol>

The new values are pasted into column B, but the formula in cell B7 is not recalculated.

Additional query words: XL97 recalc

Keywords: kbbug kbfix KB184260

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.