V
Visakha
Hi, I have a report that has 2 sections. Each section has 6 pivot tables,
all from the same data source. Initially I created each pivot table for the
1st section from scratch, indicating that I wanted to use the same data
source to save memory. Since the 2nd section was going to be identical but
with a different page fields, I copied and pasted all the pivot table from
section 1 into section 2. Unfortunately, the amount of MB has surged and
when in the workbook, it's extremely slow.
Is there a time saving way to copy and paste pivot tables without using too
much memory? I have tried going to pivotwizard and reselecting the data
source but that doesn't help. I really don't want to have to recreate
everything, especially since it took me hours to do the first time. Please
help.
all from the same data source. Initially I created each pivot table for the
1st section from scratch, indicating that I wanted to use the same data
source to save memory. Since the 2nd section was going to be identical but
with a different page fields, I copied and pasted all the pivot table from
section 1 into section 2. Unfortunately, the amount of MB has surged and
when in the workbook, it's extremely slow.
Is there a time saving way to copy and paste pivot tables without using too
much memory? I have tried going to pivotwizard and reselecting the data
source but that doesn't help. I really don't want to have to recreate
everything, especially since it took me hours to do the first time. Please
help.