How do I optimize file size in excel 2007 workbooks with pivot tab

C

Chuck Adams

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?
 

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

Excel 2007 pivot table using analysis services cube as data source 0
how to reduce byte size of pivot table ? 0
Pivot Table File Size Question 10
Link a file to a Pivot Table in another file 0
Pivot table has bloted file size - how do I bring it down 2
Excel 2013 Pivot Data Range formula reference problem 0
Pivot tables - Editing the data source shared by multiple pivot ta 1
If .xlsx is a zip archive, why does zipping it reduce file size? 5

Top