+ Reply to Thread
Results 1 to 5 of 5

Disconnect Slicer, Change Pivot Source, Reonnect Slicer

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    Istanbul, Turkey
    MS-Off Ver
    MS Office 16
    Posts
    2

    Disconnect Slicer, Change Pivot Source, Reonnect Slicer

    Hello All,

    I have a dashboard worksheet which includes several pivot tables and slicer.

    I prepared a macro with the help of a forum post by Izandol (#14) "How do i change SourceData for all pivots in workbook while disconnect/connect slicers" (I couldn't insert link)

    Please Login or Register  to view this content.
    However, I got an Invalid procedure call error on below line.

    Please Login or Register  to view this content.
    I hope someone can help me? Because I spent more than 4 hours for this problem
    BW

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Disconnect Slicer, Change Pivot Source, Reonnect Slicer

    Administrative Note:

    Welcome to the forum

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
    Read this to understand why we (and other sites like us) consider this to be important.

    As you are new I will add it for you. Please read forum rules

    https://www.mrexcel.com/board/thread...licer.1132123/
    https://www.ozgrid.com/forum/index.p...nnect-slicers/
    Last edited by Pepe Le Mokko; 04-27-2020 at 02:35 AM.

  3. #3
    Registered User
    Join Date
    04-22-2020
    Location
    Istanbul, Turkey
    MS-Off Ver
    MS Office 16
    Posts
    2

    Re: Disconnect Slicer, Change Pivot Source, Reonnect Slicer

    Quote Originally Posted by Pepe Le Mokko View Post
    Administrative Note:

    Welcome to the forum

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
    Read this to understand why we (and other sites like us) consider this to be important.

    As you are new I will add it for you. Please read forum rules
    Thank you for notice Pepe, but as I write on the first post, I couldn't insert any link. When I try I got "You are not allowed to post any kinds of links, images or videos until you post a few times.
    Your Message" notice.

    But I understand your concerns, Thank you again.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Disconnect Slicer, Change Pivot Source, Reonnect Slicer

    Insofar you only have one post that is correct.
    OTOH, you can always add a link stripped of the http part or add a sentence to indicate you cross posted and where.
    Anyway, if you have understood the importance of adding links, it's OK.

    Oh, and please do not quote entire posts unnecessarily. Use the " Quick reply" instead.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Disconnect Slicer, Change Pivot Source, Reonnect Slicer

    The error would suggest to me that the name of the slicer is incorrect. I'd start by checking those carefully against your actual slicers.
    Rory

+ 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: 09-11-2019, 11:54 AM
  2. VBA Disconnecting Slicer, Updating PivotTable Source, Reconnecting Slicer
    By CowboyFlipflop in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-22-2019, 04:00 PM
  3. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  4. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  5. Code Troubleshoot: Slicer mapping and disconnect
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2015, 01:08 PM
  6. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM
  7. Disconnect a pivot table from a slicer
    By LisaK in forum Excel General
    Replies: 5
    Last Post: 04-12-2012, 11:07 AM

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