>Thanks, it is great with one pivot table per pivot cache, but id doesn't work for multiple pivot tables connected to one pivot cache.
>
> Norbert
I really don't undertsand what you're after.
One cache for multiple pivot tables ? If so yes it does that.
Changing the source of cache and refresh to update all pivots ? If so again yes it does that.
If you still want a way to use sourcedata array sorry I don't know.
Cetin