I have a pivot table that source data is always the same, but I delete
the old data and copy in new data. A field in the data and used in
the pivot table is county. When I copy in data for NY, refresh the pivot
table, delete the source data, and copy in new data for CT, and refresh
the pivot table, the counties for NY are still "seen" by the pivot table as
an option in the drop down for that field. How do I clear the pivot table
so that only
counties in CT are options to check or uncheck in the drop down?

I have tried refreshing the pivot table when the data source area is blank,
but the pivot table still shows all NY and CT counties as options in the
drop down.
If I copy another state's data in the area and resfresh, it keeps all
counties that
it has used previously and adds the new counties. I need it to "clean" the
pivot
table with each new data set as if the pivot table was newly set up.