How to change old data source reference from copied pivot table
 

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

How to change old data source reference from copied pivot table
 

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