Mr Excelinator
New Member
- Joined
- Mar 4, 2014
- Messages
- 37
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
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