| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table File Size Question
I have a file with about 8,000 rows of data and about 30 columns. I have
about 26 pivot tables that are in one of the sheets. The file is over 13MB. If I delete the pivots my file size drops to only 6MB. My question is, A) how much space does a Pivot Table take in a file, is it the full size of the data it refrences? B) Is there a way to reduce the amount of file space of the Pivot Table? Any help would be much appreciated as a 13 MB file is very unwieldy to update and manipulate when opened, and the file just gets bigger every month. Thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table file size | Excel Discussion (Misc queries) | |||
| Pivot table has bloted file size - how do I bring it down | Excel Discussion (Misc queries) | |||
| reduce size of pivot table file | Excel Discussion (Misc queries) | |||
| pivot table cause file size to grow | Excel Discussion (Misc queries) | |||
| Pivot table - size of file? | Excel Discussion (Misc queries) | |||
Threaded Mode
