Article ID: 216005
Article Last Modified on 11/4/2003
APPLIES TO
- Microsoft Excel 2000 Standard Edition
- Microsoft Office PivotTable Component 9.0, run time
This article was previously published under Q216005
SYMPTOMS
When you click the Export to Excel button on the PivotTable toolbar, you may receive the following error message:
-and-
The totals in your Excel PivotTable do not match the totals displayed in your Microsoft Office PivotTable list.
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.
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:
- Click the title bar of your PivotTable list to select the entire table.
- Click the Property Toolbox button on the PivotTable toolbar.
- Click the Totals pane.
- Click to select the Total all items check box.
Additional query words: XL2000 pivotlist
Keywords: kbprb KB216005