+ Reply to Thread
Results 1 to 4 of 4

Clearing filters from a Pivot table

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,955

    Clearing filters from a Pivot table

    I've been using this code for a while, and this morning it keeps hanging on the "Clear Filters" part. I can't spot a reason for it, so hope that one of you can.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Clearing filters from a Pivot table

    Try.
    Please Login or Register  to view this content.
    Imagine this situation...
    Please Login or Register  to view this content.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,955

    Re: Clearing filters from a Pivot table

    I understand your reasoning, but get a "object doesn't support this property or method"

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,955

    Re: Clearing filters from a Pivot table

    Update: went ahead and rebooted my PC; now my original code is behaving just fine. Must have been some kind of software hangup.

+ 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. Clearing row labels in a pivot table
    By FindAnswers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2012, 03:04 PM
  2. way:Clearing a pivot table
    By jzibton in forum Excel General
    Replies: 3
    Last Post: 07-11-2008, 03:52 AM
  3. Clearing a pivot table
    By keithmorphett in forum Excel General
    Replies: 1
    Last Post: 11-29-2007, 01:00 AM
  4. Clearing drop down in Pivot Table
    By summergs in forum Excel General
    Replies: 3
    Last Post: 09-04-2006, 10:30 PM
  5. Clearing Pivot table
    By Wike05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2006, 12:00 AM

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