Auto refresh pivot table on Save

  • Thread starter Thread starter CindyM
  • Start date Start date
C

CindyM

Hi,
I saw macros on how to refresh pivot table when worksheet is selected.
But I am looking for reference code on how to refresh pivot tables on
entire workbook when I save the file.
 
Maybe adding code behind the ThisWorkbook module:

Option Explicit
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Me.RefreshAll
End Sub
 
Back
Top