Microsoft KB Archive/833830

= PivotTable list is slow to appear when you query the OLAP database in Excel =

Article ID: 833830

Article Last Modified on 2/12/2004

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



SYMPTOMS
When you drill-down into a PivotTable in Microsoft Excel that is attached to an Online Analytical Processing (OLAP) cube, the list of results may take longer than you expect to appear. When you update the PivotTable, any new items that you have added to the cube appear as unfiltered.



CAUSE
This behavior is by design Excel and occurs because Excel uses the EXCEPT function.



STATUS
This behavior is by design.



MORE INFORMATION
Excel uses the Multidimensional Expressions (MDX) language to query the OLAP cube. When Excel runs a query, it uses the EXCEPT function to return the differences between two sets of data. When Excel uses the EXCEPT function, your filtered data and any new data will be returned as a result of drilling down into your PivotTable.

Excel uses exclude filtering instead of include filtering because you have no way of knowing that additional items have been added to the cube unless the new items appear when you update the PivotTable. After the new items appear, you must manually remove the selection if you want to filter out the new items.

Keywords: kbprb KB833830

-

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

© Microsoft Corporation. All rights reserved.