Hi

Take a look here to see methods for clearing old items both manually and
programmatically.
http://www.contextures.com/xlPivot04.html

Regards

Roger Govier


Accountant Williams wrote:
I have created a pivot and after amending some of the columns in the data
page. I have then gone to refresh the pivot table. Although there is no
longer any cells with the old data the option to select the old data is still
being shown although it contains no info