>Cetin, this a very good soultion for one Pivot Table. My problem is that I need to update multiple PT connected to one Pivot Cache. When I used PivotTableWizard, Excel set for each Pivot Table its individual Pivot Cache and I lost the chance update all PTs in one step.
>Do you have any ideas how to solve this problem?
>
>Thanks
> Norbert

Oh I thought I originally sent you a sample creating multiple pivots from one cache, no ?
Cetin