Refreshing Pivot Tables (XL97)
Posted by DT on December 20, 2001 4:31 AM
After changing the date items in the source data field from say, May to June dates, and refreshing the pivot table, the date field in the pivot retains the 'old' itmes - showing the new June dates AND the old May dates (even though they no longer exist in the source data).
This appears to be a 'feature' and I can find no way of getting rid of the old items, other than deselecting each one individually in the pivot (not ideal).
I hope I'm not missing anything - is there a workaround?