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: Zero Values Unexpectedly Displayed in Published PivotTable List

XL2000: Zero Values Unexpectedly Displayed in Published PivotTable List

View products that this article applies to.

This article was previously published under Q210785

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB210785, kbprb

↑ Back to the top

Article Info
Article ID : 210785
Revision : 3
Created on : 10/6/2003
Published on : 10/6/2003
Exists online : False
Views : 298