Pivot table refresh problem

[Alex St-Pierre]

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

 

[Dave Peterson]

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

 

[Alex St-Pierre]

Thanks a lot, it removes all the nonused names.
There are some names that remain in the list. Like if I have type ABC2 in
the ABC case, it have replace the name ABC by ABC2 but the database still
show ABC. Is there a way to avoid that? Also, there's a name that doesn't
appear in the list.
Thanks!
Alex