Microsoft KB Archive/186688

= XL98: ROW or COLUMN Formula Is Not Updated After Cut and Paste =

Article ID: 186688

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q186688





SYMPTOMS
When you perform a cut-and-paste operation to move a range of cells that contain formulas that contain the ROW or COLUMN function, the formulas are not recalculated.



CAUSE
This problem occurs when the following conditions are true:
 * You press CONTROL+RETURN to type a formula into multiple cells. -and-


 * The formula contains the ROW or COLUMN function. -and-


 * The formula contains some operator (for example "+") or is nested in other functions (for example "=INT(ROW)") so that the formula becomes a "shared" formula. -and-


 * You move the range of formulas to another location on the worksheet.



WORKAROUND
To work around this problem, press COMMAND+SHIFT+F9. This causes Microsoft Excel 98 to recalculate the values in all open workbooks.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.



Example
To see an example of this problem, follow these steps:
 * 1) Start Microsoft Excel 98 and create a new workbook.
 * 2) Select $A$1:$A$2.
 * 3) Type =ROW*1 and press CONTROL+RETURN.
 * 4) On the Edit menu, click Cut.
 * 5) Select $F$10.
 * 6) On the Edit menu, click Paste.

The formulas in $F$10:$F$11 are not recalculated.

What Are Shared Formulas?
In Microsoft Excel, if a worksheet contains a sequence of cells that contain formulas or values that follow a distinct pattern, the formulas or values may be shared. For example, a worksheet may contain the following formulas and values:   A1: =E1+F1 A2: =E2+F2 A3: =E3+F3 A4: =E4+F4 A5: =E5+F5 A6: =E6+F6 Note the pattern in the formulas in column A. Except that row numbers increase by one in each row, each formula is identical to the formula in the row above it. Because of this pattern, the formulas in column A are shared formulas.

You can quickly place the formula in column A by selecting the range and pressing CONTROL+RETURN.

