Refresh Pivot Cache

[goss]

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

Please Login or Register  to view this content.

But the PivotTable Field List does not list the new field.

thx
w

[ag273n]

if you mean refresh the values in the pivot table, then you can try:

Please Login or Register  to view this content.