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. XL2000: Error Clicking Export to Excel When Exporting OLAP Data

XL2000: Error Clicking Export to Excel When Exporting OLAP Data

View products that this article applies to.

This article was previously published under Q216005

↑ Back to the top

Symptoms

When you click the Export to Excel button on the PivotTable toolbar, you may receive the following error message:
Totals in this PivotTable list do not include data that is hidden by filtering. When you export this PivotTable list to Excel, the totals in the Excel PivotTable report will include the hidden data, and as a result the total values in the Excel report will be different.
-and-

The totals in your Excel PivotTable do not match the totals displayed in your Microsoft Office PivotTable list.

↑ Back to the top

Cause

This problem occurs if your PivotTable list summarizes data from an Online Analytical Processing (OLAP) data source. Excel PivotTable reports do not calculate totals based on OLAP data. Excel utilizes pre-calculated totals that reside on the database server. As a result, totals in Excel PivotTable reports include hidden items.

↑ Back to the top

Workaround

To make the behavior of your PivotTable list consistent with the behavior of Excel PivotTable reports, enable the Total all items check box. To do this, follow these steps:
  1. Click the title bar of your PivotTable list to select the entire table.
  2. Click the Property Toolbox button on the PivotTable toolbar.
  3. Click the Totals pane.
  4. Click to select the Total all items check box.

↑ Back to the top

Keywords: KB216005, kbprb

↑ Back to the top

Article Info
Article ID : 216005
Revision : 1
Created on : 11/4/2003
Published on : 11/4/2003
Exists online : False
Views : 346