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

ID: Q229925

The information in this article applies to:

Microsoft Excel 2000

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 :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb