When you insert a range of cells, references that the cells contain may
not be updated relative to the addresses of the original cells that you
selected.
↑ Back to the top
This behavior can occur if the following conditions are true:
- You select the range of cells and click Cut on the Edit menu.
-and- - You select a destination range of cells and click Cut Cells on the Insert menu.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top
For more information about inserting cells, click Microsoft Excel Help on the Help menu, type insert cells, rows, or columns in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top