ID: Q113803
In Microsoft Excel for Windows, when files are saved in a workspace, splits and frozen pane settings are not saved.
This behavior is by design of Microsoft Excel.
When you open Microsoft Excel 5.0 files saved in a workspace, Microsoft Excel restores the selection, current active cell position, active page, and window. When a file saved within a workspace contains a split or frozen window pane, these settings will not be restored when the file is re-opened.
For more information about workspace settings, please see the following article(s) in the Microsoft Knowledge Base:
ARTICLE-ID: Q108474
TITLE : Window Option Not Saved in Workspace File
ARTICLE-ID: Q10042
TITLE : Zoom Setting Lost When Workspace File Saved and Reopened
Additional query words: 5.00c 7.00 xl97
Version : 5.00 5.00c 7.00
Platform : WINDOWS
Last Reviewed: November 17, 1998