Hello all,

I have a project that contains three pivot tables that all reference one query table with some calculations next to it. Since the actual project relies on another query table (with an enormous amount of data), in order to save room on our server I have coded the pivot table worksheets to copy (by worksheet object) into a new workbook.

I've done this succesfully for similar projects in the past, but the problem I seem to now be facing is that when the new workbook is saved (using Excel 2007 .xlsx), that the pivot table essentially becomes a flat file. Any attempt to drill down to the pivot table details by double-clicking on a value just pulls up an empty table. Likewise, any attempt to modify the pivot table in any way essentially clears out the pivot table's contents.

My pivot tables are precreated from the template file, and everything is done via macro, but I'm wondering if anyone else has run into this issue with pivot-table oriented VB projects.

For your reference, below is the code that does the actual copying of pivot tables, though I don't see anything within the code itself that could be the cuase of this problem.

Thanks in advance.

Please Login or Register  to view this content.
Regards,

William