Auto refresh pivot table on Save
 

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



CindyM wrote:

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.

--

Dave Peterson

Works great. Thanks.