Select the product you need help with

XL: Split or Frozen Panes Lost When You Save File in Lotus 1-2-3 Format

Article ID: 176635 - View products that this article applies to.

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Back to the top | Give Feedback

Properties

Article ID: 176635 - Last Review: August 18, 2005 - Revision: 1.1

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

kbprb KB176635

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top | Give Feedback