Results 1 to 10 of 10

(Macro) clear filter and refresh Pivot Table data without using ActiveSheet.PivotTables

Threaded View

MGadAllah (Macro) clear filter and... 09-03-2017, 02:43 PM
MGadAllah Re: (Macro) clear filter and... 09-03-2017, 05:54 PM
MGadAllah Re: (Macro) clear filter and... 09-03-2017, 06:11 PM
ottoqmoore Re: (Macro) clear filter and... 09-03-2017, 06:22 PM
MGadAllah Re: (Macro) clear filter and... 09-03-2017, 06:36 PM
MGadAllah Re: (Macro) clear filter and... 09-04-2017, 03:41 AM
MGadAllah Re: (Macro) clear filter and... 09-04-2017, 01:26 PM
ottoqmoore Re: (Macro) clear filter and... 09-04-2017, 11:03 PM
MGadAllah Re: (Macro) clear filter and... 09-05-2017, 06:53 AM
MGadAllah Re: (Macro) clear filter and... 09-05-2017, 06:14 PM
  1. #1
    Forum Contributor MGadAllah's Avatar
    Join Date
    04-13-2008
    Location
    Sheet1
    MS-Off Ver
    365,2307,16.0.16626.20170,64bit
    Posts
    190

    (Macro) clear filter and refresh Pivot Table data without using ActiveSheet.PivotTables

    The workbook I've includes several sheets, and each sheet includes a Pivot Table.
    I've gave a name for each Pivot Table in each sheet.
    Now I am making a macro to clear filter and refresh each pivot table in each sheet but I want to do it at once.
    Can I make the macro without using "ActiveSheet."
    and only add the Pivot Table name ?
    ActiveSheet.PivotTables("PivotTableName").ClearAllFilters
    The result I am looking for is to refresh each sheet and clear filter for each sheet.
    So I want to determine the pivot table name in each sheet and then choose to clear filter and refresh at once.
    Last edited by MGadAllah; 09-03-2017 at 03:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA to clear filter on pivot table row labels
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2015, 01:06 PM
  2. ActiveSheet.PivotTables => How to do it for custom sheet? (replace ActiveSheet)
    By chrisignm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2014, 03:22 PM
  3. Refresh pivot table without updating filter
    By Draagslag in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-23-2014, 09:35 AM
  4. Macro to refresh pivot table and update data source
    By TBO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 01:09 PM
  5. [SOLVED] Using VBA to change a pivot table filter, refresh the report and set up a refresh delay
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2012, 10:43 AM
  6. Excel 2007 : How to Clear Pivot Table Filter?
    By dmweinst in forum Excel General
    Replies: 2
    Last Post: 10-01-2009, 01:31 PM
  7. Pivot Table Filter Refresh Issue
    By Roachman3700 in forum Excel General
    Replies: 0
    Last Post: 11-25-2008, 05:58 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