PivotTable Column Field Values

[Michael Rekas]

Hi there

The column field list of my PivotTable (when one clicks on the
drop-down arrow) is populated with a list of items which no longer
exist in the data table from the data is drawn.

Is it possible to reset these values so that only valid data can be
selected.

Please let me know if I have not explained the problem adequqtely.

Regards

Michael

 

[Debra Dalgleish]

There are instructions here for clearing old items from a PivotTable
dropdown list:


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

 

[Michael Rekas]

Wow, That was a quick response!

Thanks Debra. The code on that page sorted this out.

regards

Michael