Split or Frozen Panes Not Saved in Workspace (113803)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
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

Modification Type:MinorLast Reviewed:8/15/2003
Keywords:KB113803
©2003 Microsoft Corporation. All rights reserved.