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. A report filter is missing in a PivotChart chart after you save the Excel 2003 workbook in Excel 2010

A report filter is missing in a PivotChart chart after you save the Excel 2003 workbook in Excel 2010

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You open a Microsoft Office Excel 2003 workbook that contains a PivotChart chart. The chart contains a report filter that was applied by using Microsoft Excel 2010.
  • You save the workbook in Excel 2010 as an Excel Workbook (*.xlsx) file.
  • You open the workbook in Excel 2003.
In this scenario, the report filter is missing.

↑ Back to the top

Cause

This problem occurs because of a limitation in the Excel 2003 import converter.

↑ Back to the top

Workaround

To work around this problem, reapply the report filter in Excel 2003.For more information about how to do this, see the following topic on the Microsoft Office Online website:
Use a report filter in a PivotTable or PivotChart report

↑ Back to the top

Keywords: KB983268, kbprb, kbsurveynew, kbexpertiseinter, kbtshoot

↑ Back to the top

Article Info
Article ID : 983268
Revision : 1
Created on : 5/24/2010
Published on : 5/24/2010
Exists online : False
Views : 389