Microsoft KB Archive/279074

= Works 6/2001: Spreadsheet Page Breaks Change When Opened in Excel 2000 =

Article ID: 279074

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Works Suite 2001
 * Microsoft Works 6.0

-



This article was previously published under Q279074



SYMPTOMS
When you open a Microsoft Works 6 or Microsoft Works Suite 2001 spreadsheet in Microsoft Excel 2000, any page breaks that you entered shift down one row, which forces data to the next page.



RESOLUTION
To work around this problem, insert a blank row, and then place your page break after it. To do this, follow these steps:
 * 1) In Works Spreadsheet, right-click the row in which you want the page break, and then click Insert Row.
 * 2) Select this blank row, and then click Insert Page Break on the Insert menu.
 * 3) Save the file.

You can now open the file in Excel 2000 without data moving to the wrong page.



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

Additional query words: Excel works 2000 2001 page break hard worksheet

Keywords: kbbug kbpending KB279074

-

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

© Microsoft Corporation. All rights reserved.