Microsoft KB Archive/211799

= XL2000: Objects May Not Appear After You Copy a Worksheet =

Article ID: 211799

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211799





SYMPTOMS
When you copy a worksheet, 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 that you are copying contains one or more embedded charts.

-and-
 * Either the Show placeholders or the Hide all option is selected. (To see these options, on the Tools menu, click Options, and then click the View tab.)



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

Method 1: Objects Are Displayed Normally
If objects appear normally, follow these steps:
 * 1) On the Tools menu, click Options, and then click the View tab.
 * 2) Under Objects, click the setting that you want to use (for example, Show all, Show placeholders, or Hide all).
 * 3) Click OK.

The change is applied to all of the worksheets in the workbook.

Method 2: Some Objects Are Not Displayed Normally
If some objects do not appear normally, follow these steps:
 * 1) On the Tools menu, click Options, and then click the View tab.
 * 2) Under Objects, click Hide all, and then click OK.
 * 3) On the Tools menu, click Options, and then click the View tab.
 * 4) Under Objects, click the setting that you want to use (for example, Show all, Show placeholders, or Hide all). Click OK.

The change is applied to all of the worksheets in 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
You can copy a worksheet by using the following steps:
 * 1) Click the worksheet that you want to copy. On the Edit menu, click Move or Copy Sheet. Or, right-click the sheet tab of the particular worksheet that 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, select a destination workbook for the copied worksheet. Specify the destination location for the copied worksheet in the Before sheet list.
 * 3) Click OK.

The three possible settings for objects in worksheets in Microsoft Excel are listed in the following table:  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.

All worksheets in a workbook use the same settings. You can change these settings for the active workbook by clicking Options on the Tools menu, and then clicking the View tab.

If you copy a worksheet, 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 if you subsequently copy that worksheet to a new 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.

Additional query words: kick gray XL2000 grey

Keywords: kbbug kbchart kbpending KB211799

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.