XL2000: Filter Settings Lost When You Move to or from Page Field (229925)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 11/5/2003 |
|---|
| Keywords: | kbprb KB229925 |
|---|
|