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?