software

Hi,

I'm really struggling with a large spreadsheet I'm developing. It has
several (dozen) pivots within the ss. I created most of them by
dragging and dropping the previous pivot table. This seems to have
been a good idea because the ss is around 8Meg.

However, I wish to adjust the ranges on the pivots. When I do this the
spreadsheet rapidly becomes MASSIVE. I suspect it's because Excel is
duplicating pivot cache.

How can I repoint all the related pivots at the same pivot cache? I've
been trying to muck around in VBA but I can't even find how to repoint
existing pivots (not sure if it's possible). I'd really appreciate
some help.

Thx.--
Wyvern
------------------------------------------------------------------------
Wyvern's Profile: www.excelforum.com/member.php...foamp;userid=5743
View this thread: www.excelforum.com/showthread...hreadid=518063There's sample code here for identifying and changing the pivot cache:

www.contextures.com/xlPivot11.html

Wyvern wrote:
gt; Hi,
gt;
gt; I'm really struggling with a large spreadsheet I'm developing. It has
gt; several (dozen) pivots within the ss. I created most of them by
gt; dragging and dropping the previous pivot table. This seems to have
gt; been a good idea because the ss is around 8Meg.
gt;
gt; However, I wish to adjust the ranges on the pivots. When I do this the
gt; spreadsheet rapidly becomes MASSIVE. I suspect it's because Excel is
gt; duplicating pivot cache.
gt;
gt; How can I repoint all the related pivots at the same pivot cache? I've
gt; been trying to muck around in VBA but I can't even find how to repoint
gt; existing pivots (not sure if it's possible). I'd really appreciate
gt; some help.
gt;
gt; Thx.
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
Worked a charm my spreadsheet has gone from a massive 150 mb to a slim
trim 3mb ... Many thanks.--
Wyvern
------------------------------------------------------------------------
Wyvern's Profile: www.excelforum.com/member.php...foamp;userid=5743
View this thread: www.excelforum.com/showthread...hreadid=518063You're welcome, and thanks for letting me know the results.

Wyvern wrote:
gt; Worked a charm my spreadsheet has gone from a massive 150 mb to a slim
gt; trim 3mb ... Many thanks.
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html