Pivot Table drop down still retains a deleted value

[DashboardNovice]

In my data set for the pivot table, in one column called CLIN, I had three possible values:

0001
0003
0004

These CLIN values can repeat many many times across hundreds of rows.

These appeared in my pivot table. So far so good. But then I went back to my raw data , filtered for and deleted 0001. I came back to my Pivot Table and refreshed it. Under the pull down arrow for the CLIN column I am still seeing a 3 previous choices when I should only see 0003 and 0004.

Why is 0001 still appearing in my Pivot Table? I even created a new PT from scratch by selecting the raw data and inserting a PT to a new sheet. I am still seeing the same problem.

 

[pecoflyer]

Have a look at http://www.contextures.com/xlPivot04.html

 

[DashboardNovice]

Have a look at http://www.contextures.com/xlPivot04.html

It worked. Thanks for the link.