Data comes from the Database into the pivot cache and then it is displayed in
the table. The pivot cache is probably huge. There are 2 things that you can
do.

One is if your tables all use exactly the same data then all of the tables
can be built off of the same cache (sometimes whe you are building a table
you will be asked if you wish to base thone table off of another which is
basically the cache).

The other thing you can do is to not store the data in the cache. Under
Table Options there is a check mark for Save Data with Table Layout. If you
uncheck that it will not save the cache. The down side is each time you open
this file you will need to refresh the tables as there is no data stored.
--
HTH...

Jim Thomlinson


"Marie" wrote:

I have an Excel file with four pivot tables that are fed from an Access
table. The Excel file is now 160+ megs. Zipped it's over 30 megs. I've
tried all the recommendations I've seen in the postings regarding deleting
unused cells, copying the pages into new files, etc., and nothing has helped.
Any recommendations? I'm using Excel 2003.