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