I have set up a Pivot table but now the worksheet that I created it from is
out of date. I have copied and pasted the new updated worksheet into the
workbook and would like to base the existing Pivot table off of this NEW
sheet without recreating the whole pivot table.

Is there a place where you can change the "source" of the pivot table????

Thanks,
barb

Go to the pilot table wizard and the go back one step to find the source.

"babs" wrote:

I have set up a Pivot table but now the worksheet that I created it from is
out of date. I have copied and pasted the new updated worksheet into the
workbook and would like to base the existing Pivot table off of this NEW
sheet without recreating the whole pivot table.

Is there a place where you can change the "source" of the pivot table????

Thanks,
barb