Exporting multiple Pivot Tables and Charts in Excel 2007

Hi guys,

Last year I wrote a very nice piece to automatically generate Pivot Charts, thanks to your help (special thanks to romperstomper . Now I had to migrate to Office 2007, and the macro is not working anymore

The issue is the following: I create Pivot Tables and associated Pivot Charts in worbook Test.xlsm, and this works. I then try to export them to a separate workbook, PivotReport.xlsx. When I do this, the "link" between the Pivot Tables and the Pivot Charts is broken, and my charts now become ordinary Chart sheets, so I cannot change the Field Items, I cannot filter them, etc.
I enclose the sample workbook, where I put a simplified version of the code. The problem appears when the subroutine MoveSheetsToWorkbook is executed: until that point, the Pivot Charts are still real Pivot Charts, with the associated Tags. Let me know if there's something I should clarify,

Thanks,

Sergio Rossi

No ideas anyone? Would it help if I posted directly the code instead than a workbook? I thought the workbook would have been more helpful for you to understand the problem...if there's anything I could do to sparkle interest in this thread, let me know, I'd happy to try Thanks for reading anyway!

Best Regards

Sergio Rossi