Pivot auto refresh VBA when pivot in same sheet with data source

[excelakos]

Hi everyone!
I ve been searching the web but managed to find zero about this.

I need a vba in order to auto update several pivot tables all of which are placed in the same sheet. In addition the data source also placed in the same sheet.

The data source is a named table. I would like all pivot tables to be updated once any value in this table is changed.

Thank you in advance

 

[lhartono]

Add Command Button and copy this to Pivot Sheet Module,

[COLOR=#d3d3d3]'[/COLOR]
[COLOR=#0000cd]Private Sub CommandButton1_Click()

ActiveWorkbook.RefreshAll

End Sub[/COLOR]
[COLOR=#d3d3d3]'[/COLOR]

 

[excelakos]

Hi Ihartono thank you for your interest. If i understand correct your solution includes a bit of manual action like i would use the refresh all button in my excel ribbon.
I need a vba to auto update pivots once any value in the source table is changed. You see the source table itself getting feeds from other sources etc...