Article ID: 108474
Article Last Modified on 8/15/2003
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q108474
SYMPTOMS
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
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.
REFERENCES
For more information about creating and saving a workspace file, click the Search button in Help and type:
workspace files
Additional query words: 5.00a 5.00c 8.00 97 XL97 XL
Keywords: kbualink97 kbui kbprb KB108474