Microsoft KB Archive/214355

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

Article ID: 214355

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214355





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, and then close and 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: The WK1 file format does not support many advanced features, such as drawing objects, complex formatting, and so on; therefore, use this workaround with caution. -or-


 * Manually insert the split or frozen panes (click Freeze Panes on the Window menu) when you reopen the file in Microsoft Excel.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: XL2000

Keywords: kbbug kbpending KB214355

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.