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

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


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


Michael Rekas wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Wow, That was a quick response!

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

regards

Michael

On Fri, 10 Dec 2004 08:56:22 -0500, Debra Dalgleish
wrote:

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


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


Michael Rekas wrote:
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.