Hi
Having copied your PT to another sheet, right click in the PT to bring
up the PT toolbar.
Select the Pivot Table dropdown, then the PT wizard.
Click back twice and change the data source to your new data source.

--
Regards

Roger Govier



Bonbon wrote:
Hi, im just wondering is there any way of changing the data in a
Pivot table? Because i want to copy the pivot table to a different
sheet, but use different data.

Any help would be hugely appreciated
bonbon