H
Huyeote
Someone passed to me a workbook which contains many pivot tables on
separated sheets. After examine those pvt, I found they all point to
same data source, which makes the workbook unnecesssarily large (5MB).
I check every single pvt's in VBE and found they have their own pivot
cache. My question: how can I assign all pvt to just one pivot cache to
save space without start building pvt all over again?
Thanks.
Huyeote
separated sheets. After examine those pvt, I found they all point to
same data source, which makes the workbook unnecesssarily large (5MB).
I check every single pvt's in VBE and found they have their own pivot
cache. My question: how can I assign all pvt to just one pivot cache to
save space without start building pvt all over again?
Thanks.
Huyeote