Excel: Reloading external data to a Pivot Table (overwriting cache!)

[steela]

Hi,

I'm having a problem with a pivot table containing data from an external source: It seems that on creation of the pivot, all the records sourced from the external data are stored in the Pivot Table cache. So when I update my external data source, and refresh the pivot table, the data is still coming from the cache and not the source data which has now changed.

Is there anyway of refreshing the cached data from the source data (preferably using VBA)?

Thanks!

Aimee

 

[SkipVought]

Hi,

How is your data source defined in the PT Wizard?

What kind of data source is it? Excel, Access...

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[steela]

It's an analysis services cube....