Hi
I am using Excel 2003 and creating pivots, does anybody know a way of cleaning the Pivot Field filter dropdowns.
I have a field which had some bad data loaded, when you look at the dropdown filter is showed the correct data and the wrong data, having cleaned up the source data the dropdowns still showed the rubbish data and I have never been able to get rid of it, unless I rebuild the pivot again.
Anyway of reseting these dropdowns
Regards
Mike