Hi,
I am trying to copy out a worksheet to a new workbook. This worksheet includes a pivotchart and a pivotable, where the pivottable is the charts datasource.
When i copy the sheet to a “New” book, the chart is no longer linked to the pivotchart and it remains static.
As part of my cloning...