Clear filters in pivot tables in MS 2010
Results 1 to 5 of 5

Thread: Clear filters in pivot tables in MS 2010
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2011
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Clear filters in pivot tables in MS 2010

    I am trying to clear the filters in the pivot tables. I removed the information in the main spreadsheet, but it still remains in my drop down in my pivot tables and is starting to become a big problem. I have tried taking out the report filter field -- removing the main filter than re-adding. Is there any way to clear them without re-doing all my pivot tables? I have 15 tables and would require re-formatting.
    Thanks so much!!!

  2. #2
    Board Regular
    Join Date
    Apr 2011
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Clear filters in pivot tables in MS 2010

    Hello - Justin pinging this post to see if anyone knows how to clear the pivot table filters. I have used the worksheet as a template for other work and have all the old remains in my new workbook without any of the info in the sheet that pulls the pivot table; however, my pivot table filters have the info from my previous worksheet. (Info that I removed from my previous worksheet). So looking for a way to remove the info that is still listed in my pivot table filters that I have removed in my main worksheet. Thanks so much!

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,756
    Post Thanks / Like
    Mentioned
    65 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Clear filters in pivot tables in MS 2010

    Quote Originally Posted by Jadegirl View Post
    I am trying to clear the filters in the pivot tables. I removed the information in the main spreadsheet, but it still remains in my drop down in my pivot tables and is starting to become a big problem. I have tried taking out the report filter field -- removing the main filter than re-adding. Is there any way to clear them without re-doing all my pivot tables? I have 15 tables and would require re-formatting.
    Thanks so much!!!
    Try this

    Code:
    Sub Clear_filters()
        Dim sh As Worksheet, pt As PivotTable, pi As PivotItem
        For Each sh In Sheets
            For Each pt In sh.PivotTables
                pt.ClearAllFilters
            Next
        Next
    End Sub
    Regards Dante Amor

  4. #4
    Board Regular
    Join Date
    Apr 2011
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Clear filters in pivot tables in MS 2010

    HI - thanks so much for responding!! I have tried this several times and it isn't clearing. Do you have any other suggestions? So hoping to get the junk out of the worksheet -- it makes selecting items really tricky.

  5. #5
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,756
    Post Thanks / Like
    Mentioned
    65 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Clear filters in pivot tables in MS 2010

    Quote Originally Posted by Jadegirl View Post
    HI - thanks so much for responding!! I have tried this several times and it isn't clearing. Do you have any other suggestions? So hoping to get the junk out of the worksheet -- it makes selecting items really tricky.
    You could upload a sample of your file to know exactly what your problem is.

    You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •