Resetting a Pivot Table

[rguy84]

Is there a way for a pivot table's filter to be reset? On sheet one, I have my data, one of the columns is a team name. Some teams have a grandchild team. My boss only wants parents and children, so I removed all "/grandchildren." However /grandchild is still an option to filter by.

Also, can I get insight as to why the following doesn't work?

Sub refresh_click()
'    Dim pt As PivotTable
'
'    Set pt = Worksheets("Stats").PivotTables("HDstats")
'    pt.RefreshTable
    ActiveWorkbook.RefreshAll
    Worksheets("Contact").Calculate
End Sub

The table doesn't update and the formula on Contact stays at 00:00.

 

[rguy84]

bump