Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172203

From BetaArchive Wiki
Knowledge Base

XL97: Copying Sheet Does Not Preserve Drawing Object Numbers

Article ID: 172203

Article Last Modified on 10/21/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q172203


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 named "Rectangle 1" and "Rectangle 2."

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


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.


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL97

Keywords: kbbug KB172203