ID: Q108474
The information in this article applies to:
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 Options dialog box.
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
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. For more information about split, frozen, or zoomed panes, please see the following articles in the Microsoft Knowledge Base:
ARTICLE-ID: Q113803
TITLE : XL: Split or Frozen Panes Not Saved in Workspace
ARTICLE-ID: Q10042
TITLE : XL5: Zoom Setting Lost When Workspace File Saved
and Reopened
For more information about creating and saving a workspace file, click the Search button in Help and type:
workspace files
Keywords : kbualink97 kbui kbdta xlloadsave xlui
Version : WINDOWS:5.0,5.0c,7.0,97; MACINTOSH:5.0,5.0a
Platform : MACINTOSH WINDOWS
Issue type : kbprbLast Reviewed: January 7, 1999