XL2000: Clicking "Export to Excel" Results in Blank Excel PivotTable (234030)


The information in this article applies to:

  • Microsoft Excel 2000
  • 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.
Modification Type:MajorLast Reviewed:11/4/2003
Keywords:kbprb KB234030
©2003 Microsoft Corporation. All rights reserved.