Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Filter Settings Lost When You Move to or from Page Field

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

View products that this article applies to.

This article was previously published under Q229925

↑ Back to the top

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.

↑ Back to the top

Cause

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

↑ Back to the top

Keywords: KB229925, kbprb

↑ Back to the top

Article Info
Article ID : 229925
Revision : 3
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 199