Microsoft KB Archive/884405

= Filtered items in an OWC that is connected to an SQL Server 2000 Analysis Services database are not filtered when you export the data to Excel =

Article ID: 884405

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Office Web Components
 * Microsoft Office Web Components
 * Microsoft SQL Server 2000 Analysis Services

-



SYMPTOMS
When you filter items in a Microsoft Office Web Component (OWC) that is connected to a Microsoft SQL Server 2000 Analysis Services database, the filtered items are not filtered when you export the data to Microsoft Excel.



CAUSE
This issue occurs because Excel does not permit filtering of items that are not visible in an OWC Pivot Table.



WORKAROUND
To work around this issue, expand the filtered data before you export the OWC data to Excel.

Additional query words: owc owcxp owc2003 owc10 owc11 NOT_IN_THE_VIEW member discarded

Keywords: kbtshoot kbofficewebchart kbprb kbofficewebpivot kbofficewebspread KB884405

-

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

© Microsoft Corporation. All rights reserved.