HI Roger, I tried that and it didnot work, i applied the script which was on
the website of contextures and that only worked on the Data fields but the
values in the Page boxes still existed after running the macro

"Roger Govier" wrote:

Hi Linda

On the PT, drag the field off the PT, use the Refresh button on the PT
toolbar, then drag the field back to its original location.

--
Regards

Roger Govier


"Linda Monincx" <Linda wrote in
message ...
I have a pivot sheet referring to a dataset where I have period which i
want
to have as a data set. now was that for example 200511. I deleted that
info
and now only have other values there like 200601 or so but in the
dropdown
box of the period ( data column) this old value 200511 is still there
I can't
get ride of it ( in the dropdown) not even after refreshing the pivot.

How do i make sure that values which are not in the Datasource anymore
are
being removed from all dropdown boxes (page, row as data)

Regards,

Linda Monincx