XL2000: Manual Page Break Does Not Move in Excel 5.0/95 File

• Microsoft Excel 2000

SYMPTOMS

In Microsoft Excel, manual page breaks in a worksheet automatically shift position when you insert or delete rows or columns. However, when you open a file that was saved in the "Microsoft Excel Workbook 5.0/95" file format in Microsoft Excel 2000, Microsoft Excel does not automatically shift manual horizontal page breaks when you delete or insert rows.

NOTE: This behavior persists if the workbook is subsequently saved as a Microsoft Excel 2000 workbook.

CAUSE

The problem occurs when the following conditions are true:

• You select a cell that is not in the first row and click Page Break on the Insert menu to insert a manual horizontal page break in a workbook.
  
  -and-



• You save the workbook from Microsoft Excel version 5.0 or 7.0 or you save the file in Microsoft Excel 2000 in the Microsoft Excel 5.0/95 Workbook file format.
  
  -and-



• You open the workbook in Microsoft Excel 2000.
  
  -and-



• You insert or delete one or more rows above the manual horizontal page break in the workbook.

RESOLUTION

To correct this problem, remove and reinsert manual page breaks in the affected document. To do this, follow these steps:

1. Select the cell location of the manual page break.
   
   NOTE: If you do not see the manual page breaks, click Page Setup on the File menu and click OK.



2. On the Insert menu, click Remove Page Break.



3. With the same cell location of the manual page break selected, click Page Break on the Insert menu.



4. Repeat steps 1 through 3 for every manual page break on the workbook.

STATUS

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

MORE INFORMATION

A manual page break in an Excel 5.0/95 workbook remain on the same row when rows are inserted or deleted in Microsoft Excel 2000. Columns shift as in earlier versions of Excel when you insert or delete columns.

REFERENCES

For more information about page breaks, click Microsoft Excel Help on the Help menu, type "page breaks" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words:

Keywords : kbprint kbdta xlloadsave
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug