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

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

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
--
Alex St-Pierre


"Dave Peterson" wrote:

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