Article ID: 211710
Article Last Modified on 10/8/2003
APPLIES TO
- Microsoft Excel 2000 Standard Edition
This article was previously published under Q211710
SYMPTOMS
In Microsoft Excel, if you cut and paste or drag a range of cells from one worksheet to another worksheet, you may receive the following error message:
When you click OK, merged cells in the destination worksheet may become unmerged. If you click the Edit menu, you cannot undo the operation.
CAUSE
This problem occurs if the following conditions are true:
- You cut and paste or drag a range of cells from one worksheet to another worksheet.
-and-
- The destination worksheet is protected.
-and-
- The destination range of cells includes one or more merged cells that are locked.
Note that this problem does not occur if you copy and paste a range of cells from one workbook to another.
WORKAROUND
To work around this problem, use either of the following methods.
Method 1
Manually merge the unmerged cells. To do this, select the cells and either click Merge and Center on the Formatting toolbar or click to select the Merge cells check box on the Alignment tab of the Format Cells dialog box.
Method 2
Close the destination workbook without saving it, and then reopen the workbook.
WARNING: Use this method with caution because you may lose other changes to the workbook.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
Additional query words: XL2000
Keywords: kbbug kbpending KB211710