Someone passed me a workbook which contains many pivot tables on
separated sheets. After examining those pvt, I found they all point to
exactly same data source but have different pivot cache, which makes
the workbook unnecesssarily large (10MB). My question: how can I assign
all pvt to just one single pivot cache to save space without start
building pvts all over again?

Thanks.

Huyeote


--
Huyeote
------------------------------------------------------------------------
Huyeote's Profile: http://www.excelforum.com/member.php...o&userid=13894
View this thread: http://www.excelforum.com/showthread...hreadid=270005