Copied Pivot Tables with same data source

V

Visakha

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top