Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Blank rows and page breaks are removed from your Excel 97 PivotTable report when you open the report in Excel 2000

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

View products that this article applies to.

This article was previously published under Q210701

↑ Back to the top

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.

↑ Back to the top

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-

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

-and-

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

-and-

You open the file in Microsoft Excel 2000.
3.You open the file in Microsoft Excel 2000.
Excel 97 does not maintain any of the settings contained in the PivotTable Field Layout dialog box.

↑ Back to the top

Status

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

↑ Back to the top

Keywords: KB210701, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 210701
Revision : 4
Created on : 12/2/2004
Published on : 12/2/2004
Exists online : False
Views : 347