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

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.

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

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.