XL97: Objects May Not Appear After Copying Worksheet
ID: Q169351
|
The information in this article applies to:
-
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:
- On the Tools menu, click Options. Click the View tab.
- Under Objects, click the setting 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.
Method 2: Some Objects Are Not Displayed Normally
If some objects do not appear normally, use the following steps:
- On the Tools menu, click Options. Click the View tab.
- Under Objects, click Hide All.
- Click OK.
- On the Tools menu, click Options. Click the View tab.
- Under Objects, click the setting 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 this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
In Microsoft Excel 97, you can copy a worksheet by using the following
steps:
- 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.
- 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.
- 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
selecting the View tab.
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.
Additional query words:
XL97 kick gray
Keywords : kbchart xlui xldraw
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbprb
|