Hi all,

Using Excel 2010.

I added a new column to the data source I am using for the PivotCache
How can I refresh the PivotCache so I see the new field in the PivotTable Field List?

I tried
 For Each pc In .PivotCaches
     pc.Refresh
 Next pc
But the PivotTable Field List does not list the new field.

thx
w