XL2000: Blanks Sorted Differently in Office PivotTable List

ID: Q207526

The information in this article applies to:

Microsoft Excel 2000
Microsoft Office PivotTable Component 9.0, run time

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 :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug