+ Reply to Thread
Results 1 to 2 of 2

HOW TO -Using same Pivot cache -different worksheets

  1. #1
    Forum Contributor
    Join Date
    08-22-2013
    Location
    columbus,oh
    MS-Off Ver
    Office 365
    Posts
    190

    HOW TO -Using same Pivot cache -different worksheets

    I have a pivot table that I created and now I want to use the same pivot cache to create another pivot table instance on a different worksheet.
    how can I do that?
    My first worksheet gets saved as "OO By buyer" and now I want to create a new worksheet and drop the next pivot there.
    Thanks!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: HOW TO -Using same Pivot cache -different worksheets

    New worksheet or new workbook?

    If it is a new workSHEET, click in the pivot table, click on OPtions, under the PivotTable portion of the ribbon, choose Select dropdown, then select entire PivotTable. Press the Copy button, then go to the new worksheet and click paste. Same pivotCache, two tables.
    Last edited by mikeTRON; 07-07-2014 at 03:34 PM.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. pivot cache
    By mezy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 01:07 PM
  2. Create multiple pivot tables from pivot cache
    By dpatel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2010, 12:24 PM
  3. Create the Pivot cache and pivot macro
    By krishna.chvg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2010, 10:03 PM
  4. Pivot table cache
    By keithmorphett in forum Excel General
    Replies: 3
    Last Post: 11-16-2007, 06:56 AM
  5. [SOLVED] Pivot cache
    By Kreed in forum Excel General
    Replies: 0
    Last Post: 11-14-2005, 05:20 PM

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