Knowledge Base

Split or Frozen Panes Not Saved in Workspace

Article ID: 113803

Article Last Modified on 8/15/2003

Microsoft Excel 97 Standard Edition

This article was previously published under Q113803

SUMMARY

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.

MORE INFORMATION

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 in the Microsoft Knowledge Base:

108474 Window Options Are Not Saved in Workspace Files

10042 Zoom Setting Lost When Workspace File Saved and Reopened

Additional query words: 5.00c xl97 XL

Keywords: KB113803