XL2002: Data in Target Cells Is Lost When You Use Paste Special Command (287102)
The information in this article applies to:
This article was previously published under Q287102 SYMPTOMS
When you use the Paste Special command in Microsoft Excel to copy column widths or validation criteria, the data in the target cells may be lost.
CAUSE
This behavior occurs if both of the following conditions are true:
- You select and copy cells that are not a continuous range.
-and- - You use the Paste Special command with either the Validation or Column Widths option.
WORKAROUND
To work around this issue, select a continuous range of cells rather than by selecting discontinuous cells as a group, or select the cells individually and then copy them and use the Paste Special options.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
This behavior occurs only when you use the two Paste Special options Validation and Column widths, and only when you select a group of cells that form a discontinuous group by pressing CTRL while you select them. It does not occur with other Paste Special options, nor when you select a continuous range of cells.
| Modification Type: | Major | Last Reviewed: | 4/7/2001 |
|---|
| Keywords: | kbbug KB287102 |
|---|
|