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

ID: Q234030

The information in this article applies to:
  • Microsoft Excel 2000
  • Microsoft Office PivotTable Component 9.0, run time

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

Keywords : kbdta xlpivot
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: June 10, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.