Microsoft KB Archive/229925

= XL2000: Filter Settings Lost When You Move to or from Page Field =

Article ID: 229925

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q229925



SYMPTOMS
When you move a field from the row or column field area of your PivotTable to the page field area, all filter settings on the field are lost.

When you move a field from the page field area to the row field or the column field area of your PivotTable, all filter settings on the field are lost.



CAUSE
This problem will occur if your PivotTable is based on an Online Analytical Processing (OLAP) data source.

Additional query words: XL2000 tensor

Keywords: kbprb KB229925

-

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

© Microsoft Corporation. All rights reserved.