Microsoft KB Archive/207526

= XL2000: Blanks Sorted Differently in Office PivotTable List =

Article ID: 207526

Article Last Modified on 2/23/2004

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.