Hi,

I would like some help please. I have a swag of pivot tables (that
I've structured to all point to the same pivot cache). As part of a
regular process I need to assign this cache to point to new Data files
and new Data ranges.

I've found a pice of code that seems to do it when you are creating a
new pivot cache (using SourceData:= Range("A1").CurrentRegion.Address)
but I'm not sure how to modify an existing pivot range.

Can anyone please help?

Many thanks,

Geoff


--
Wyvern
------------------------------------------------------------------------
Wyvern's Profile: http://www.excelforum.com/member.php...fo&userid=5743
View this thread: http://www.excelforum.com/showthread...hreadid=521991