Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Clicking "Export to Excel" Results in Blank Excel PivotTable

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

View products that this article applies to.

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.

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB234030, kbprb

↑ Back to the top

Article Info
Article ID : 234030
Revision : 3
Created on : 11/4/2003
Published on : 11/4/2003
Exists online : False
Views : 343