Microsoft KB Archive/210701

= Blank rows and page breaks are removed from your Excel 97 PivotTable report when you open the report in Excel 2000 =

Article ID: 210701

Article Last Modified on 12/2/2004

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q210701



SYMPTOMS
In Microsoft Excel 2000, when you open a workbook that was saved in Microsoft Excel 97, your PivotTable report may not be displayed or printed as expected. Blank rows and page breaks are removed from your PivotTable report.



CAUSE
This problem occurs when you do the following:  In Excel 2000, you select any of the following settings in the PivotTable Field Layout dialog box for any of the fields in your PivotTable report:

 Show items in outline form Insert blank line after each item Insert page break after each item

-and-

You open, and then save the file in Microsoft Excel 97.

-and-

You open the file in Microsoft Excel 2000. You open, and then save the file in Microsoft Excel 97.

-and-

You open the file in Microsoft Excel 2000. You open the file in Microsoft Excel 2000.</li></ol>

Excel 97 does not maintain any of the settings contained in the PivotTable Field Layout dialog box.

<div class="status_section">

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: XL2000 roundtrip round-trip frt

Keywords: kbbug kbpending KB210701

-

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

© Microsoft Corporation. All rights reserved.