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

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

Cool, thanks Roger, that helped =)
There another problem though, when i copy the new data source for the PT (as
a Macro record) it continues to select this range, but for the new PTs i need
the Newer data source. Do you know what is the code i need to solve this?

Thx in advance,
Bonbon

"Roger Govier" wrote:

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