vba refresh all pivot tables in workbook code example

Example 1: vba refresh pivot table

Private Sub Worksheet_Deactivate()
  ThisWorkbook.RefreshAll
End Sub

Example 2: excel vba Refreshing all pivot tables in workbook

ThisWorkbook.RefreshAll