Hi All,

Just in case anyone experiences this problem too. I did find out how
to do it. But my final solution was to create my own pivot cache and
then spawn all the required pivot tables (2000+) from the created
caches.

Whilst it did take me quite a while to figure out how to do this, it
proves a far more robust solution than creating pivot tables manually
and modifying the cache. They tend to behave in strange ways
sometimes.

Geoff


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