Microsoft KB Archive/192871

= XL98: Window Options Are Not Saved in Workspace File =

Article ID: 192871

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q192871





SUMMARY
In Microsoft Excel, when you open a workspace file, all the workbooks in the workspace file have the following Window Options settings on the View tab of the Preferences dialog box (click Preferences on the Tools menu).   Window Options          Setting -

Automatic Page Breaks  Clear (or Page Breaks)

Formulas               Clear

Gridlines              Selected

Color                  Automatic

Row & Column Headers   Selected

Outline Symbols        Selected

Zero Values            Selected



MORE INFORMATION
Window options are saved in each individual workbook. If you save a workbook with the Gridlines option cleared, when you open the workbook, gridlines are not displayed.

Workspace files save the workbooks you have open, including their size, arrangement, and position on the screen. When you open a workspace file, all of your workbooks appear with the same settings they had when you closed them. However, when you save a workspace file, the Automatic Page Breaks (or Page Breaks), Formulas, Gridlines, Color, Row & Column Headers, Outline Symbols, or Zero Values options are not saved. When you open a workspace file, all the workbooks are displayed with the default settings listed above.

Additionally, split, frozen, or zoomed panes on a worksheet are not always saved in a workspace file.

