OFF95: View Changes for Microsoft Excel Worksheet in Binder Lost

Last reviewed: March 10, 1997
Article ID: Q130970
7.00 WINDOWS kbtool

The information in this article applies to:

  • Microsoft Office for Windows 95, version 7.0
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Office Binder, when you change a view setting for a Microsoft Excel worksheet in your Binder, for example if you turn off the display of sheet tabs, when you save the Binder and then open the Binder again, the change may not appear in the Microsoft Excel worksheet.

CAUSE

This behavior occurs because some of the view changes that you make to a Microsoft Excel worksheet are not saved when you are editing a worksheet in the Office Binder. For example, if you turn off the vertical scroll bar in a worksheet in a Binder, and save the Binder, when you open the Binder again, the vertical scroll bar appears again in the Microsoft Excel worksheet.

The following worksheet view options that appear on the View tab in the Options dialog box in Microsoft Excel are NOT retained when you close the Binder that contains the worksheet and open it again:

Show

   Formula Bar

Window Options
   Automatic Page Breaks
   Horizontal Scroll Bar
   Vertical Scroll Bar
   Sheet Tabs

The remaining settings on the View tab are saved; namely Note Indicator, Formulas, Gridlines (and Color), Row & Column Headers, Outline Symbols, and Zero Values.

STATUS

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.


KBCategory: kbtool kbfasttip
KBSubcategory: offwin

Additional reference words: 7.00

Keywords : offwin kbfasttip kbtool
Version : 7.00
Platform : 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 10, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.