how to change old data source reference from copied pivot tables

A

arun

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
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change old data source reference from copied pivot table 1
Excel 2007 pivot table using analysis services cube as data source 0
Excel 2013 Pivot Data Range formula reference problem 0
Easy way to change Pivot table source files? 5
Are copied Pivot Tables "linked" to each other ? 2
How can I change the source data reference to another pivot table? 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
pivot tables 4

Top