Window Options Are Not Saved in Workspace File

   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, the Gridlines option remains cleared.

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, workspace files do not save Window Options settings, so the Window Options settings are displayed with the default settings listed above.

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