Hi Jester,

What I recommend is that you set up one table, and base the rest of the
tables on that one table - this minimises the number of tables caching data.

Alternatively, you could send the data out, and automate the creation of the
tables with VBA using the On Open event.

Hope this helps

Warm regards

Sunil Jayakumar
"jester1072" wrote in message
...
I have a large spreadsheet of data (around 16mb) and I need to do lots of
pivot tables from that data. I have moved the pivot tables to a seperate
workbook but the file size is nearly 100MB and this makes it pretty
unusable.
Is there any way to compress data in the pivot tables so you can still see
the data but keep the files small? Cheers for any help


www.ayyoo.com/credit-cards.html