Microsoft KB Archive/89397

{|
 * width="100%"|

Excel: Works 2.0 Sheets with Splits Open in Two Windows

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0

-

SUMMARY
When opening a Microsoft Works version 2.0 for Windows worksheet containing a split in Excel 4.0, the split will not be displayed. Instead, two synchronized windows will be displayed. The windows will be synchronized either horizontally or vertically, depending on the way the original Works worksheet was split. If the Works worksheet was split both vertically and horizontally, the sheet will open in Excel with two vertically synchronized Windows.

MORE INFORMATION
In order to have the document display as it did in Works, the worksheet splits must be reset in Excel. First, close the second window view, designated as &quot;SHEETNAME:2 [VSYNC]&quot; (without the quotation marks), by activating it and double-clicking on the document control bar in the upper- left corner of the worksheet. Next, choose Split from the Window menu. The split appears above and to the left of the active cell. To adjust where the split is place, click where the panes intersect and move it to the desired location.

If a Microsoft Works 2.0 worksheet containing a split is loaded into either Microsoft Excel 2.1 or 3.0, the split will not be displayed, and multiple windows do not result.