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

ID: Q186688

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

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.

The formula contains the ROW or COLUMN function.

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.

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.

MORE INFORMATION

Example

To see an example of this problem, follow these steps:

Start Microsoft Excel 98 and create a new workbook.

Select $A$1:$A$2.

Type =ROW()*1 and press CONTROL+RETURN.

On the Edit menu, click Cut.

Select $F$10.

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.

REFERENCES

For more information about ROW worksheet function, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

ROW worksheet function

and then click Show Topics. Select the "ROW" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

For more information about COLUMN worksheet function, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

COLUMN worksheet function

and then click Show Topics. Select the "COLUMN" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: shared formula XL98

Keywords : kbdta xlformula
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug