How do I clear the Field pulldowns after the data is cleared?

I am using a pivot table to present data. The old data will be cleared and
new data entered weekly. The data labels are remembering the previous data,
even after it is cleared. I have tried refresh, but that does not clear the
data. Can anyone help?

To clear old items from the pivot table, you can use one of the
techniques shown here:

http://www.contextures.com/xlPivot04.html


Fred wrote:
> I am using a pivot table to present data. The old data will be cleared and
> new data entered weekly. The data labels are remembering the previous data,
> even after it is cleared. I have tried refresh, but that does not clear the
> data. Can anyone help?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html