XL2000: Blanks Sorted Differently in Office PivotTable List (207526)
The information in this article applies to:
- Microsoft Excel 2000
- 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.
| Modification Type: | Major | Last Reviewed: | 2/23/2004 |
|---|
| Keywords: | kbbug kbpending KB207526 |
|---|
|