Norbert,
Sorry, don't know. You may have to create a VB wrapper to assign the array.
>Hi Daniel,
>thank you very much for your advice, this is a good solution for one PivotTable, but it divides the one common Pivot Cache into individual Pivot Caches for each Pivot Table. I really need pass arrays to a variant property SoiurceData. Or, if you know any onther solution, how to set Source Data for Pivot Cache, I would be thankful.
>
>Thanks
> Norbert Kustra
Daniel