Microsoft KB Archive/170936

= References Updated Incorrectly After Inserting Cells =

Article ID: 170936

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q170936





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 click Cut Cells on the Insert menu.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

