Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Window options are not saved in a workspace file in Excel

View products that this article applies to.

This article was previously published under Q214297

↑ Back to the top


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

   Page breaks             Clear

   Formulas                Clear

   Gridlines               Selected

   Color                   Automatic

   Row & column headers    Selected

   Outline symbols         Selected

   Zero values             Selected

   Horizontal scroll bar   Selected

   Vertical scroll bar     Selected

   Sheet tabs              Selected

↑ Back to the top


To work around this behavior, follow these steps:
1.Open the workspace file.
2.Close the workbook that displays the expected Window options settings.
3.Open the workbook that displays the expected Window options settings.
The workbook appears with all of the expected Window options settings displayed, and with the size, arrangement, and position on the screen as saved in the workspace.

↑ Back to the top

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.

↑ Back to the top


For more information about creating and saving a workspace file, click Microsoft Excel Help on the Help menu, type save a group of workbooks in a customized workspace in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB214297, kbui, kbprb

↑ Back to the top

Article Info
Article ID : 214297
Revision : 5
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 39