Pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the same set of pivot tables on several worksheets. Is there a way to copy them to a new sheet and just change the data referenced? So I don't have to keep rebuilding them?


Thanks,



Todd
 
In the copied worksheet, select the pivot table, and then click the pivot
table wizard.
Click back until you see the address of the original sheet. Somehting like
[Book1]Sheet1!$A$5:$C$14.
Change this to the new sheet name.


Todd said:
I am using the same set of pivot tables on several worksheets. Is there a
Click to expand...
way to copy them to a new sheet and just change the data referenced? So I
don't have to keep rebuilding them?
 
You must log in or register to reply here.

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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pre-configuring Pivot table "views" 4
copy pivot table to multiple worksheets 2
Average of Subtotals in Pivot Table 0
Workbook pivot table design function 6
Can a pivot table be redirected to an external source? 1
Merge 2 datasheets into single Pivot Table. 2
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1

Back
Top