Pivot table Refresh from a change to data validation list change

[wisemank]

I would like to have my pivot table refresh from the drop down data selected. I am refreshing the "Hours required" by selecting different scenarios. This is what I did and nothing updates. The data on my dataset updates but not the pivot table.

Sub UpdateSummary()
'
' UpdateSummary Macro
' Refreshes the Pivot Summary

Range("M4").Select

ActiveWorkbook.RefreshAll
End Sub

 

[Alex Blakenburg]

If you right click on the Tab (sheet name) of the sheet with the input cell and select View Code.
Then in the window that it takes you to paste in the following, does it do what you want ?
(Change the M4 in the intersect line to the input cell)

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("M4")) Is Nothing Then   '<--- put the address of your input cell here
        Application.EnableEvents = False
        ' UpdateSummary Macro
        ' Refreshes the Pivot Summary
        Range("M4").Select
        ActiveWorkbook.RefreshAll
        Application.EnableEvents = True
    End If

End Sub

 

[wisemank]

Brilliant... Many thanks.