Results 1 to 5 of 5

Creating multiple pivot tables from one PivotCache

Threaded View

Phixer Creating multiple pivot... 07-07-2015, 03:55 PM
Phixer Re: Creating multiple pivot... 07-08-2015, 08:13 AM
Parth007 Re: Creating multiple pivot... 07-08-2015, 09:21 AM
Phixer Re: Creating multiple pivot... 07-08-2015, 10:15 AM
Phixer Re: Creating multiple pivot... 07-09-2015, 11:46 AM
  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Tallahassee, FL
    MS-Off Ver
    Excel 2010
    Posts
    98

    Creating multiple pivot tables from one PivotCache

    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.

    ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=XSourceData, Version:=xlPivotTableVersion14).CreatePivotTable TableDestination:="'Test'!R5C1", TableName:="Test", DefaultVersion:=xlPivotTableVersion14
    Help?
    Last edited by Phixer; 07-09-2015 at 11:47 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-12-2013, 02:28 AM
  2. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2013, 10:49 PM
  3. Creating Multiple Pivot tables
    By keithabailey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2009, 03:26 PM
  4. Creating multiple pivot tables using VBA
    By Sam_Gregson in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-04-2009, 12:42 PM
  5. Multiple Pivot tables using single Pivotcache
    By doozer1979 in forum Excel General
    Replies: 1
    Last Post: 03-07-2008, 08:11 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1