+ Reply to Thread
Results 1 to 2 of 2

How to make this code for changing pivot table filters apply to one worksheet

  1. #1
    Forum Contributor
    Join Date
    04-14-2008
    Location
    Fort Collins, Co
    MS-Off Ver
    2016
    Posts
    107

    How to make this code for changing pivot table filters apply to one worksheet

    I need to make the following code only apply to pivot tables in a specified worksheet. For example, changing the data validation is cell A3 will only update the pivot tables in sheet1

    Please Login or Register  to view this content.
    Is That Your Spreadsheet Or Did Your Database Just Throw Up?


  2. #2
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: How to make this code for changing pivot table filters apply to one worksheet

    Try doing a small change on it:

    Please Login or Register  to view this content.
    I hope that works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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