Refresh Pivot Table in protected sheet

Hello,

So I have a Dashboard that has a pivot table lined into about 6 charts. they are all linked to one tab "Data" which constantly has data being input. The dashboard tab is protected to where only the filtering tools can be messed with. I want to be able to go in my "data" tab and input the data and when i go back to my dashboard where the pivot table is, I want it to automatically update.

I put in the following code but it does not work. Can anyone see the problem or have another idea for a code that would work?

Private Sub worksheet_activate()
ActiveSheet.PivotTables(1).RefreshTable
End Sub


Private Sub workbook_open()
With Me.Worksheets("dashboard")
.AllowPivotTable = True
.Protect Contents = True, userinterfaceonly:=True
AllowUsingPivotTable = True

End With
End Sub


Thanks.

Bump no response