| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reduce the size of a file that contains pivot tables
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to reduce the size of a file that contains pivot tables
Dag Monique
Is this useful for you: http://www.mrexcel.com/archive2/7800/8646.htm Groeten Wigi -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Monique Goethals" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reduce an Excel with Pivot Tables file size? | Excel Discussion (Misc queries) | |||
| Minimize the size of a file that contains multiple Pivot Tables | Excel Discussion (Misc queries) | |||
| reduce size of pivot table file | Excel Discussion (Misc queries) | |||
| minimize the file size in a ppt with collections of many pivot tables | Excel Discussion (Misc queries) | |||
| Large Excel file size, no pivot tables | Excel Discussion (Misc queries) | |||
Linear Mode
