Creating multiple pivot tables from one PivotCache

[Phixer]

I need to understand the VBA needed to do it.

I have the code to create the cache and the pivot tables on one page, but I don't want to create a new cache on each sheet. I want to be able to create one cache, then use that one cache to create many pivot tables.

Please Login or Register  to view this content.

Help?

[Phixer]

Wow, according to this no one has ever done this before, or been able to do this before. I am surprised.

Guess I will be the first.

[Parth007]

hey Phixer,

Please refer below link

http://www.excelforum.com/excel-gene...ivotcache.html

[Phixer]

I need to do it using VBA, so there is no prompt that pops up to which one can say Yes.

Right now the only way I know to do it is to copy the sheet, then alter the pivot table, which can be fraught with problems. Thus, I am seeking code to do it.

[Phixer]

AHA!

Just because no one ever explained how to do it before, it CAN be done.

Please Login or Register  to view this content.

This will create a new pivot table, with pre-existing cache #1

Want to know what details are in each cache?

Please Login or Register  to view this content.

I hope this helps someone.