XL2000: Saving File in Excel 97 Loses PivotTable Field Layout Options

• Microsoft Excel 2000

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:

1. 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-
   
   
2. You open, and then save the file in Microsoft Excel 97.


-and-


3. You open the file in Microsoft Excel 2000.

STATUS

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

Additional query words: XL2000 roundtrip round-trip frt

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