Auto Update Pivot Table

[djmurray]

Hey guys,

I have built a dashboard in excel using a couple MSSQL queries and then I filter the data in a pivot table.

The only problem I have is that the data in the pivot is not updating unless I refresh.

I am populating a few sheets in a table and have set them to auto refresh every 3 minutes.

Is there any way to make all the pivot table update after the data in the tables has updated?

(there are multiple pivots in the same sheet)

Appreciate any assistance!

 

[jorismoerings]

Hi,

In the VBA Project, select the worksheet that house the pivot table, then type the below event code....

Private Sub Worksheet_Activate()
    ThisWorkbook.RefreshAll
End Sub

This will update your pivot on all sheets as soon as you activate this sheet.

Is this what you're looking for?