Pivot Charts - Copy And Repoint

In Excel 2007, it is not directly possible to change the data source for a pivot chart, but this code that shows how to copy a worksheet while repointing the pivot charts to the copied pivot table, rather than the having them reference the source pivot table.

Right-click to Save Target As: VBA_CopyAndRepoint.txt

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License