+ Reply to Thread
Results 1 to 4 of 4

Using pivot table slicers in shared spreadsheet

  1. #1
    Registered User
    Join Date
    04-16-2021
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    91

    Using pivot table slicers in shared spreadsheet

    I have created a spreadsheet with a couple of pivot tables, which will be used as a shared spreadsheet on Sharepoint. I've used slicers so people can easily filter to see what they want to see, however I am concerned that slicers will amend the pivot table for everyone and if there are multiple people using the spreadsheet at the same time if will cause frustration. Is there a way around this?

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Using pivot table slicers in shared spreadsheet

    I dont know much about sharepoint but Turn off the autosave feature for that file after they have opened it?

  3. #3
    Registered User
    Join Date
    04-16-2021
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    91
    Thanks for the reply, but I'm reluctant to turn off autosave. We use the 365 version, so everyone with permissions can edit at the same time and there are 20 people with edit access.
    Last edited by AliGW; 04-22-2024 at 09:06 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.

  4. #4
    Registered User
    Join Date
    04-16-2021
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    91

    Re: Using pivot table slicers in shared spreadsheet

    Re-opening this old thread to see if anyone has any ideas on how to do this without turning off autosave. It seems crazy that there would be a sheet view to filter the source data but not to filter the pivot tables.

+ 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: 1
    Last Post: 07-14-2021, 11:03 AM
  2. [SOLVED] Pivot Table & Slicers
    By Statz in forum Excel General
    Replies: 3
    Last Post: 10-09-2017, 09:35 PM
  3. Slicers for Pivot Table
    By Balzer13 in forum Excel General
    Replies: 1
    Last Post: 08-03-2017, 10:36 AM
  4. [SOLVED] Is there any way to tell if a pivot table has slicers?
    By ChemistB in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-07-2016, 12:56 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. Can you have pivot table fields as slicers?
    By no.18shirt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2013, 05:12 PM
  7. Replies: 2
    Last Post: 05-24-2013, 03:58 PM

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