Microsoft KB Archive/107976

Microsoft Knowledge Base

XL: Objects Setting Applies to Entire Workbook

Last reviewed: March 27, 1997
Article ID: Q107976

5.00 7.00 | 5.00

WINDOWS   | MACINTOSH

kbusage kbtlc

The information in this article applies to:

• Microsoft Excel for Windows, version 5.0
• Microsoft Excel for the Macintosh, version 5.0
• Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Microsoft Excel, the Objects setting (located on the View tab in the Options dialog box) can be set to one of three options: Show All, Show Placeholders, or Hide All. The setting you choose applies to all sheets in the current workbook.

In earlier versions of Microsoft Excel, the Objects setting is set for each individual sheet.

Because of this difference in how Object options are set, when you open a Microsoft Excel 4.0 workbook in Microsoft Excel versions 5.0 and 7.0, you may notice that objects are visible when they should be hidden.

MORE INFORMATION

When you open a Microsoft Excel version 4.0 workbook in either Microsoft Excel version 5.0 or 7.0, the setting in the workbook that makes the most objects visible will be applied to all of the sheets in the workbook. For example, if you open a workbook that contains the following sheets and settings

   Sheet    Object Setting
   -----------------------

   Sheet1   Hide All
   Sheet2   Show Placeholders
   Sheet3   Show All

all the sheets will use the Show All option. If you open a workbook with these settings

   Sheet    Object Setting
   -----------------------

   Sheet 1  Hide All
   Sheet 2  Show Placeholders
   Sheet 3  Hide All

all sheets will use the Show Placeholders option.

KBCategory: kbusage kbtlc KBSubcategory: Additional reference words: 5.00 7.00 Keywords : kbtlc kbusage Version : 5.00 7.00 | 5.00 Platform : MACINTOSH WINDOWS THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: March 27, 1997 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.