Thread: How do I clear the Field pulldowns after the data is cleared?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default How do I clear the Field pulldowns after the data is cleared?
To clear old items from the pivot table, you can use one of the
techniques shown he

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

Reply With QuoteReply With Quote