XL2000: Copying Sheet Does Not Preserve Drawing Object Numbers (212107)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q212107

SYMPTOMS

When you move or copy a worksheet in a workbook, the names of drawing objects in the moved or new worksheet appear to be renamed.

For example, if you create two rectangles, one named Rectangle 2 and another named Rectangle 4, and you copy the sheet, the rectangles are renamed Rectangle 1 and Rectangle 2.

NOTE: To determine the name of an object, click the object. The name of the object appears in the Name box in the upper-left corner of the worksheet.

CAUSE

This problem occurs if the following conditions are true:
  • You create three or more drawing objects on a worksheet.

    -and-
  • You delete any of the drawing objects you created.

    -and-
  • You copy or move the worksheet.

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:11/5/2003
Keywords:kbbug kbpending KB212107
©2003 Microsoft Corporation. All rights reserved.