Arun,

to change the datasource of a pivottable, use the PivotTable-Assistant.

Regards,
Dominik.


arun schrieb:
Hi All,

I need to change the old datasource references from copied sheets having
pivot tables and charts.

But i am not getting any way to find solution by any means.

Kindly help me on this regards.

Thanks,
arun