Thanks Debra. ChangePivotCache was just what I wanted, once I figured out I had
to change Sheets("Pivot") to one of my sheets with a pivot table in it.

It changed my 90Mb file to 30Mb.

--
Regards,
Fred


"Debra Dalgleish" wrote in message
...
And after you set up one pivot table to use a dynamic range as its source,
there's code here that will set all the pivot tables to use the same cache:

http://www.contextures.com/xlPivot11.html

Fred Smith wrote:
Thanks, Dave.

I did use the wizard to go back and change the source range, but it didn't
look to me like it saved any space (although I don't know how to tell for
sure).

I'll either live with it, or recreate the pivot tables. I like Deb's dynamic
range idea.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html