Why does my pivot table column filter show values which aren't in the source data ?
Posted on 2011-02-15
I created a pivot table from source data containing names of towns. The column filter showed the list of towns available in the data. I then changed the source data and replaced the towns with new towns.
However, the pivot table filter shows not only the new town names but also the old ones (even though they aren't in the source data).
I've tried a Refresh but the names are still in the filter list.
How do I remove these inappropriate towns from the filter list ?