Changing the data of a Pivot Table
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 |
Changing the data of a Pivot Table
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 |
Changing the data of a Pivot Table
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 |
All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com