XL: Split or Frozen Panes Lost When You Save File in Lotus 1-2-3 Format
Article ID: 176635
Article Last Modified on 8/18/2005
APPLIES TO
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 for Macintosh
- Microsoft Excel 5.0a for Macintosh
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 95a
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q176635
SYMPTOMS
When you save, close, and then reopen a file that contains worksheets that
contain split or frozen panes, the following problems may occur:
- The frozen or split panes are removed from the worksheets in the
file.
- The active cell is not visible on the screen, and you have to scroll
through the worksheet to view the cell.
CAUSE
These problems occur if you save the file in the Lotus 1-2-3 WK3 or WK4
file format.
NOTE: This problem does NOT occur if you save an individual worksheet in
the Lotus 1-2-3 WK1 file format, close, and then reopen the worksheet.
WORKAROUND
To work around this problem, use either of the following methods:
- If you are using only a single worksheet, try saving the worksheet in
the Lotus 1-2-3 WK1 file format.
Note that the WK1 file format does not support many advanced features,
such as drawing objects, complex formatting, and so on, so use this
workaround with caution.
-or-
- Manually insert the split or frozen panes (click Split or Freeze Panes
on the Window menu) when you reopen the file in Microsoft Excel.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words: XL5 XL7 XL97 freeze panes
Keywords: kbprb KB176635