Hi,
Go to the pivot table, at the top centre of the screen you will see
Pivottable tools click on that, then go to data, 5th tab from the left and
click on chane data Source, same procedure with the charts

If this was helpful please click yes, thanks

"arun" wrote:

Hi All,

I wanted to change the old datasource reference from my copied sheets
having pivot tables and charts.

I copied the sheets from other workbook.

how can i resolve this issue, i am not geting any way to overcome this issue.

If any body has any solution, kindly let me know. I am using excel 2007.

Thanks in Advance