XL2000: Incorrect 3-D Formula Reference After Undo or Redo Paste (215217)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q215217

SYMPTOMS

In Microsoft Excel, when you undo a cut and paste operation, or redo a cut and paste operation, one or more formulas may show an incorrect value.

CAUSE

This behavior occurs when you do the following:
  1. Cut a 3-D reference.Paste the cells in a new location.Cancel selection of the 3-D reference.Undo the paste operation.
  2. Paste the cells in a new location.Cancel selection of the 3-D reference.Undo the paste operation.
  3. Cancel selection of the 3-D reference.Undo the paste operation.
  4. Undo the paste operation.
-or-
  1. Cut a 3-D referencePaste the 3-D reference in a new location.Undo the paste operation.Cancel the selection of the 3-D reference.Redo the paste operation.
  2. Paste the 3-D reference in a new location.Undo the paste operation.Cancel the selection of the 3-D reference.Redo the paste operation.
  3. Undo the paste operation.Cancel the selection of the 3-D reference.Redo the paste operation.
  4. Cancel the selection of the 3-D reference.Redo the paste operation.
  5. Redo the paste operation.
This behavior occurs because the formula is not updated to refer to the correct cells after completing the undo or redo operation.

WORKAROUND

To work around this behavior, reselect the 3-D reference that the formula refers to before you undo or redo the paste operation.

For example, with the following formula

=SUM('Sheet1:Sheet3'!$A$1)

if you cut the range $A$1 in sheets 1 through 3 and then paste into a new range, reselect $A$1 in sheets 1 through 3 before you undo this paste operation.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbbug kbnofix KB215217
©2003 Microsoft Corporation. All rights reserved.