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?
 
Back
Top