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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>

Thanks,

That was exactly what I needed.


"Shah Shailesh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>>
>>
>
>