Microsoft KB Archive/234030

= XL2000: Clicking "Export to Excel" Results in Blank Excel PivotTable =

Article ID: 234030

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 Q234030



SYMPTOMS
When you open a Web page that contains a Microsoft Office PivotTable Component, and click the Export to Excel button on the PivotTable toolbar, the resulting Excel PivotTable does not contain any data.



CAUSE
This problem occurs when you have not added a total field to your PivotTable list.



WORKAROUND
To add a total field to your PivotTable list, follow these steps:
 * 1) Click the heading for the detail field that you want to summarize.
 * 2) Click the AutoCalc button on the PivotTable toolbar, and then click the function that you want to use to summarize the data.

Totals are added to your detail field.

Additional query words: XL2000 pivotlist empty

Keywords: kbprb KB234030

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.