+ Reply to Thread
Results 1 to 2 of 2

Wanting to create a copy of pivot with slicers

  1. #1
    Registered User
    Join Date
    05-20-2010
    Location
    rotherham
    MS-Off Ver
    office 365
    Posts
    48

    Wanting to create a copy of pivot with slicers

    Hi.
    Hoping I can get some help please with regards to a pivot table with slicers.
    I have created a pivot in a spreadsheet with slicers which works perfectly (sheet1). However this is a shared spreadsheet and I would like the second user to use a copy of this pivot table but in the same spreadsheet, separate sheet (sheet2)

    I copied the sheet and then put on new slicers but every time I user the slicers in sheet1 , it affects sheet2 - visa versa. I am sure there is a simple solution. I didn't want to recreate the pivot but if this is the case then I will have to do this. I also want the data to be kept in the same document.

    The data is reading from data in power query too.,

    Many thanks for the assistance

    Jacc14

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,821

    Re: Wanting to create a copy of pivot with slicers

    My first suggestion is to check the slicer connections. If the slicers on both sheets are connected to the pivot tables on the "other sheet" then you can deselect those connections.
    If it isn't a connection issue, then we may be in better position to help if we could see a sample file.
    (Information is in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page)
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 0
    Last Post: 09-05-2024, 08:33 PM
  2. [SOLVED] Wanting to create a loop
    By fellodan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2019, 07:39 AM
  3. Copy new workbook lost connection betwenn pivot tables and slicers
    By okat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2017, 11:00 AM
  4. Replies: 0
    Last Post: 03-06-2017, 03:55 PM
  5. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  6. Wanting to create collapsable rows
    By Miss.Rubixcube in forum Excel General
    Replies: 1
    Last Post: 01-12-2014, 11:29 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