Microsoft KB Archive/205675

= XL2000: Totals Missing From PivotTable Published From Excel =

Article ID: 205675

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Office PivotTable Component 9.0, run time

-



This article was previously published under Q205675



SYMPTOMS
When you open a Web page that contains a Microsoft Office PivotTable list, you may experience one of the following symptoms:  One or more of the data fields may be blank. The following heading appears for one or more of the data fields:

No Totals

-or-

 One or more of the data fields in the PivotTable may not appear until you click Expand on the PivotTable toolbar. The PivotTable will not include totals for one or more of the data fields in your PivotTable.



CAUSE
This problem will occur if the following conditions are both true:
 * The PivotTable list was published using a PivotTable stored on a Microsoft Excel worksheet
 * You have chosen one of the following options in the Show Data As list in the PivotTable dialog box:


 * Difference From
 * % Of
 * % Difference From
 * Running Total in
 * % of row
 * % of column
 * % of total
 * Index

Additional query words: XL2000 pivotlist

Keywords: kbprb KB205675

-

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

© Microsoft Corporation. All rights reserved.