XL2000: Zero Values Unexpectedly Displayed in Published PivotTable List (210785)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Office PivotTable Component 9.0, run time
This article was previously published under Q210785

SYMPTOMS

When you publish a Microsoft Excel PivotTable report, some data field values in the resulting Microsoft Office PivotTable list may be displayed as 0, even though the data field in the source Excel PivotTable report does not contain any zero values.

CAUSE

This problem occurs when the following conditions are true:
  • One of the fields that you add to the data area of your Excel PivotTable report contains blank values.

    -and-

  • You are using the Min function to summarize the data field.
The Office PivotTable component calculates a value of 0 for blank values, but Excel PivotTable reports do not include blank values in numeric calculations.
Modification Type:MajorLast Reviewed:10/6/2003
Keywords:kbprb KB210785
©2003 Microsoft Corporation. All rights reserved.