Knowledge Base

XL98: References Do Not Update After Inserting Cells

Article ID: 178738

Article Last Modified on 9/11/2002

Microsoft Excel 98 for Macintosh

This article was previously published under Q178738

SYMPTOMS

When you insert a range of cells, references that the cells contain may not be updated relative to the addresses of the original cells you selected.

CAUSE

This problem occurs when the following conditions are true:

You select the range of cell and click Cut on the Edit menu. -and-
You select a destination range of cells and insert the cut cells.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about inserting cells, click the Index tab in Microsoft Excel 98 Help, type the following text

inserting cells

and then double-click the selected text to go to the "Insert cells, rows, or columns" topic.

Additional query words: XL98

Keywords: kbprb KB178738