Need workbook to refresh when I change dropdown list value

[jaguinaga]

I have two separate values in my data validation drop down list. I need a set of pivot tables to refresh automatically when I select the different dropdown options (A or B). What can I do to add a refresh?

 

[RasGhul]

Hi maybe the following,

Be sure to save a test copy of your workbook

Right Click Sheet tab / View Code / In the VBA prompt Change General in drop down to Worksheet

Note that for every event change, this sheet will RefreshAll. If your only changing 1 drop down selection this should be ok.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    ThisWorkbook.RefreshAll

End Sub

 

[jaguinaga]

Thank you!