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: Blanks Sorted Differently in Office PivotTable List

XL2000: Blanks Sorted Differently in Office PivotTable List

View products that this article applies to.

This article was previously published under Q207526

↑ Back to the top

Symptoms

When you open a Web page that contains a Microsoft Office PivotTable list, blank values (shown as (Blank) in row fields and column fields) are displayed at the top of the list of values. This differs from the behavior of Excel PivotTables, in which blank values are displayed at the bottom of the list by default.

↑ Back to the top

Cause

The Office PivotTable Component displays blank values at the top of the list by default. This behavior is by design.

↑ Back to the top

Keywords: KB207526, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 207526
Revision : 4
Created on : 2/23/2004
Published on : 2/23/2004
Exists online : False
Views : 346