ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copied Pivot Tables with same data source (https://www.excelbanter.com/excel-programming/435632-copied-pivot-tables-same-data-source.html)

Visakha

Copied Pivot Tables with same data source
 
I have a report with 2 sections. Each section has about 6 tables. When I
created the first section, I created the pivots from scratch and based them
on the same data source to conserve on memory. Then I copied and pasted
these pivot tables into section 2, and then adjust the page fields. When I
did this, the memory amount surged so much that it slows everything down. Is
there a macro or something else that helps with this?


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com