XL97: Objects May Not Appear After Copying Worksheet

• Microsoft Excel 97 for Windows

SYMPTOMS

When you copy a worksheet in Microsoft Excel 97, the following problems may occur:

• AutoShapes, drawing objects, charts, and other objects in the worksheet that do not appear or that are represented by placeholders in the original worksheet are displayed.

      -or-
  

• AutoShapes, drawing objects, charts, and other objects appear on one worksheet but not in another worksheet even though they are present in the worksheet.

CAUSE

These problems occur if the following conditions are true:

• The worksheet you are copying contains one or more embedded charts.

      -and-
  

• Show Placeholders or Hide All is selected in the View tab of the Options dialog box.

WORKAROUND

To work around this problem, use the following appropriate method to reset the Objects setting.

Method 1: Objects Are Displayed Normally

If objects appear normally, use the following steps:

1. On the Tools menu, click Options. Click the View tab.

2. Under Objects, click the setting you want to use (for example, Show All, Show Placeholders, or Hide All).

3. Click OK.

Method 2: Some Objects Are Not Displayed Normally

If some objects do not appear normally, use the following steps:

1. On the Tools menu, click Options. Click the View tab.

2. Under Objects, click Hide All.

3. Click OK.

4. On the Tools menu, click Options. Click the View tab.

5. Under Objects, click the setting you want to use (for example, Show All, Show Placeholders, or Hide All).

6. Click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

In Microsoft Excel 97, you can copy a worksheet by using the following steps:

1. Click the worksheet you want to copy. Then, click "Move or Copy Sheet" on the Edit menu. Or, right-click the sheet tab of the worksheet you want to copy, and then click Move Or Copy on the shortcut menu.

2. In the Move Or Copy dialog box, click to select the Create A Copy check box. In the To Book list, click a destination workbook for the copied worksheet. Specify the destination location for the copied worksheet in the Before Sheet list.

3. Click OK.

   Setting             Definition
   ----------------------------------------------------------------------
   Show All            All objects are displayed normally.

   Show Placeholders   Objects are displayed in gray; you can see the
                       shape of the object but not its contents.

   Hide All            Objects are not displayed.

If you copy a worksheet in Microsoft Excel 97, the Objects setting for the destination workbook is automatically reset to Show All regardless of its previous setting.

In addition, if the setting of the copied worksheet is Hide All, and you copy the worksheet in a single workbook, objects in the original worksheet may not be visible even though the setting for the workbook is Show All. If this behavior occurs, use the second method in this article to restore the objects on the worksheet to the normal behavior.