Knowledge Base

XL2000: Blanks Sorted Differently in Office PivotTable List

Article ID: 207526

Article Last Modified on 2/23/2004

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

This article was previously published under Q207526

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.

CAUSE

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

Additional query words: XL2000

Keywords: kbbug kbpending KB207526