Pivot table refresh to refresh filter as well

[ADB123]

Hi Guys

I us the below code to refresh my pivot table after importing fresh data. I could like to choose the new date range to update the SCHED_DATE filter before going on to the next code.

Any help will be apriciated


Sub RefreshAllPivotTables()

Dim PT As PivotTable
Dim WS As Worksheet

For Each WS In ThisWorkbook.Worksheets

For Each PT In WS.PivotTables
PT.RefreshTable
Next PT

Next WS

End Sub

 

[Monty]

Hello ADB123

Code provided by you work very well to refresh all the pivot tables in the existing workbook.

Please let us know what else you are looking for!

 

[Monty]

Please unlock your sample file you have provided protected with password!

 

[Monty]

if you are not aware follow the screenshot!

 

[Monty]

If you dont know the password, please follow the link our experts explaned.

http://chandoo.org/forum/threads/help-in-removing-updating-vba-macro-password.29727/#post-177647

 

[Arpanakumar]

Thanks, now i know how to remove password.