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
|