Clear filters in pivot tables in MS 2010

[Jadegirl]

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!!!

 

[Jadegirl]

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!

 

[DanteAmor]

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

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

 

[Jadegirl]

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.

 

[DanteAmor]

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.