Pivot Table Workbook File Size

**Airdrielad** · 12-22-2010, 05:40 AM

Hi,

I have the following code, which produces 3 pivot tables from the same data in the same workbook. The code then copies all 3 pivot tables and saves them on a new workbook in a particular location. My problem however, is that the file size that is far too large. When I create the same report manually, the file size is only kb instead of MB. Currently, using the code, the filesize is 5.5mb. I don't want to past the pivot tables as values only, as the recipients need to be able to double click on the pivot table entries and see the original report and other fields not included in the actual pivot.

Can anyone help?

I have attached an example file with the code included.

**arthurbr** · 12-22-2010, 06:06 AM

Are you using the same Pivot cache for all the tables?

**Airdrielad** · 12-22-2010, 06:12 AM

Yes, I am using the same Pivot Cache for all the pivot tables.

**Airdrielad** · 12-29-2010, 12:45 PM

Worked it out for myself, eventually, I copied the data to the new worksheet first of all and used a "last row " function to whittle down the sourcedata instead of selecting whole colums. Have dramatically reduced my saved pivot table worksheet from 5.54mb to 367 kilobytes!