How to clear / update filter

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
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.
 

Attachments

  • filter_history.xlsx
    13.2 KB · Views: 13

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
I mean the filter button. Pls see my screendump.
 

Attachments

  • filter_history2.jpg
    filter_history2.jpg
    34.6 KB · Views: 20
Top