+ Reply to Thread
Results 1 to 2 of 2

Interaction through slicers only, block modification pivot table fields

  1. #1
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Question Interaction through slicers only, block modification pivot table fields

    Hi,

    trying to set up a pivot table which can be modified only by slicers
    but if select the checkbox of "use pivot table reports" when protecting the sheet, the user can modify which fields are displayed on the pivot table
    if I do not select the checkbox, then when using the slicer, error occurs.

    any workaround out-there?

    any tips welcome

    thank you!!

  2. #2
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Re: Interaction through slicers only, block modification pivot table fields

    Hey,

    in case someone else is looking for the answer, i found it here
    http://www.pivot-table.com/2013/08/0...t-table-setup/

    all is in the pt.enablewizard property which can only be changed by code

    regards,

+ 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. [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
  2. Pivot Table Formatting - Slicers
    By aaaaaron42 in forum Excel General
    Replies: 0
    Last Post: 10-05-2015, 12:59 PM
  3. [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
  4. Use combobox value to filter Pivot Table like slicers using VBA
    By limalf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 07:31 PM
  5. 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
  6. Can you have pivot table fields as slicers?
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-19-2013, 10:39 AM
  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