Hi Charles;

This should work

ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh

Thanks,

Greg
-----Original Message-----
After having deleted Items in Source Data Table and
refreshed Pivottable
Items still in Drop-down list of field in Pivottable.

How can Drop-down list of a field in Pivottable be
cleared of all
redundant Items?

--

Charles Janssens




.