| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I optimize file size in excel 2007 workbooks with pivot tab
I am created large workbooks with as many as 16 pivot tables within. I have
three data sets that drive the tables. As you would expect these files are quite large at around 40megs. Everytime I refresh the data the file size increases. All tables from the same data source seem to be linked, thus should be refferencing the same cached copy of the data. I have uncheck the "save source data with the file" and "enable show details" options and have saved the data in a seperate workbook. Asside from zipping them is there anything more that I can do to reduce the size of these files? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 File Size | Excel Discussion (Misc queries) | |||
| How to reduce file size when converting to pdf for excel 2007? | Excel Discussion (Misc queries) | |||
| Excel 2007 export file size huge | Excel Discussion (Misc queries) | |||
| How reduce the file size of Excel 2007 files (wasted non value spa | Excel Discussion (Misc queries) | |||
| how to reduce file size of excel workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
