Debra Dalgleish does.
http://contextures.com/xlPivot04.html
and
http://contextures.com/xlVideos07.html#ClearOld

Alex St-Pierre wrote:

Hi!
I use a macro to modify a pivot table. This line return an errror.
ActiveSheet.PivotTables("PivotTable1").PivotFields ("Name").CurrentPage = "ABC"

The field "ABC" is include in the "Name" column but in the pivot table, I
cannot select it. If I go to the field parameter and click to show item
without data, "ABC" and a lot of other Names I have already deleted will
appear. The "ABC" column is not an empty column. Does anyone know how to
completly refresh a pivot field (using macro of not)?
Thanks a lot!
Alex
--
Alex St-Pierre

--

Dave Peterson