Article ID: 178985 - View products that this article applies to.
This article was previously published under Q178985
This article has been archived. It is offered "as is" and will no longer be updated.
When you copy a worksheet in Microsoft Excel 98 Macintosh Edition, the following problems may occur:
These problems occur if the following conditions are true:
To work around this problem, use the following appropriate method to reset the Objects setting.
Method 1: Objects Are DisplayedIf objects appear in the worksheet, use the following steps:
Method 2: Some Objects Are Not DisplayedIf some objects do not appear, use the following steps:
NOTE: If the Objects setting for 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 Objects 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.
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.
In Microsoft Excel 98 Macintosh Edition, you can copy a worksheet by using the following steps:
All worksheets in a workbook use the same settings. You can change these settings for the active workbook by clicking Preferences on the Tools menu, clicking the View tab, and selecting different settings.
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 98 Macintosh Edition, Microsoft Excel automatically selects Show All under Objects in the View tab of the Preferences dialog box for the destination workbook. This is true regardless of the previous setting for the destination workbook.
Article ID: 178985 - Last Review: October 7, 2013 - Revision: 1.0