Help with Pivot chart loosing connections when copied to new workbook

[Mr Excelinator]

Morning Chaps.

Hope someone can help with this.

I've a master workbook spooling off output reports using VBA, which are in effect slimmed down copies of the master workbook containing the source data, pivot tables with pivot charts & slicers - so looks & feels like a dynamic report for the user.

Everything works OK but the pivot chart loses its connection to the output pivottable in the output workbook so it doesn't change with slicer selection.
Has anyone a method to stop that from happening OR a piece of code you use to reset the links to the output workbooks pivottable?

Many thanks!
Stu. aka Mr Excelinator

 

[ectiger86]

Bump

 

[deletedalien]

I literally Just tried this and it works with no probs.

i have slicers and all.

Maybe you are using an OLAP pivot?

 

[deletedalien]

Nope... Just tried this with an OLAP pivot and still works...

are you copying the sheet tab? (that's what i did and worked)