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.