How to reduce the size of a file that contains pivot tables

  • Thread starter Monique Goethals
  • Start date
M

Monique Goethals

I have a worksheet which contains a large 'raw data' tab - 100 columns by
19000 rows.
My 'raw data' tab already has a size of 20MB. No calculations or special
formatting.

I use this raw data to create multiple pivot tables. I only create the first
pivot from scratch and create the other pivots from my base pivot. This
usually makes my file size grow to 45MB.

today tried to overwrite my raw data with updated information, hoping that i
shouldn't have to recreate my pivots and only refresh them. I adjusted my
named range and refreshed the pivot and all seemed to be OK.
EXCEPT the filesize had gone up to 170MB.

I have no idea what caused this size increase and how I can overcome this
issue.
I just want to be able to use a pivot template so that i only have refresh
the data.
 

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

Similar Threads

Pivot Table File Size Question 11
2007 Pivot to Access 1
Pivot Table file size 4
View Pivot Table Source data as a Data Table 6
Open the world of Pivot Tables 1
Building pivot tables in Excel 2007 based on existing pivot tables? 4
Pivot Table Refreshing of Data 1
Pivot tables - Editing the data source shared by multiple pivot ta 1

Top