| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reduce size of pivot table file
I created a pivot table that draws on a very large set of data - the file is
7MB. I have since removed most of the data and slimmed the table down to only 10% of what was referenced before. The file is still 4MB. The table or worksheet still seems to contain some data/links that it no longer needs. I have removed all the fields and refreshed but this doesn't work. I have another file that contains the same quantity of information and a pivot table, but it's only about 200kb. WHY?!? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| pivot table | Excel Discussion (Misc queries) | |||
| pivot table cause file size to grow | Excel Discussion (Misc queries) | |||
| Why size of email with pivot table is so big? | Excel Discussion (Misc queries) | |||
| Pivot table - size of file? | Excel Discussion (Misc queries) | |||
Threaded Mode
