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.