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