PDA

View Full Version : How to clear / update filter



whoiswct
2012-12-21, 02:07 PM
Please refer to my attached sample.
First, the data source column A contain A,B,C,D.
Then, I create a Pivot Table.
Then, I delete the whole row C in data.
Refresh data source. However, the PT filter still have A,B,C,D even though data only contain A,B,D.

Ken Puls
2012-12-21, 04:31 PM
Hey there,

When I open your sample file, I'm only seeing rows A, B, D in the PivotTable. I deleted Row B in the Data sheet, then refreshed and, as expected, I end up with A, D in the PivotTable.

Have you tried closing Excel and re-opening it? Sometimes it can get messed up and stop working properly. Not sure if that's the case here, but it's worth checking.

whoiswct
2012-12-22, 12:17 PM
I mean the filter button. Pls see my screendump.

Ken Puls
2012-12-22, 05:12 PM
Ah, have a look at this: http://www.contextures.com/xlPivot04.html

whoiswct
2012-12-23, 01:42 AM
thanks.

Sent from my phone using Tapatalk