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

ID: Q215217

The information in this article applies to:
  • Microsoft Excel 2000

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.
  2. Paste the cells in a new location.
  3. Cancel selection of the 3-D reference.
  4. Undo the paste operation.
-or-
  1. Cut a 3-D reference
  2. Paste the 3-D reference in a new location.
  3. Undo the paste operation.
  4. Cancel the selection of the 3-D reference.
  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 this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000

Keywords : xlformula
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: June 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.