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!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks