Clear Unused Column Filter List Values in Pivot Table

[AMDRIT]

Hello Everyone,

I have a Pivot table that is dynamically linked to data, over time, the
filter data on the columns will become obsolete. My question is how do I
clear the invalid values? PivotTable("tableName").PivotCache.Refresh()
doesn't seem to do it.

TIA

 

[Shah Shailesh]

See below link.

http://www.contextures.com/xlPivot04.html




Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

http://in.geocities.com/shahshaileshs/menuaddins
(Free addins old\classic Office Menu-2003 for Office-2007)

 

[AMDRIT]

Thanks,

That was exactly what I needed.

See below link.

http://www.contextures.com/xlPivot04.html




Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

http://in.geocities.com/shahshaileshs/menuaddins
(Free addins old\classic Office Menu-2003 for Office-2007)