Worksheet Change Refresh Connection

[wsnyder]

Hi all,

Using Excel 2016.

I created a connection only in Power Query to table on my worksheet with a single row to be used as a file parameter.
The parameter can be 1 of 2 values based on selection by user and that part is working as expected.

I added a bit of code to the Worksheet Change Event, but it does not seem to be doing anything

Private Sub Worksheet_Change(ByVal Target As Range)

ActiveWorkbook.Connections("Query - myquery").Refresh

End sub

It should return the path and name of the new file selected by the user, but it is still showing the last selection.
What am I missing?

Thanks,
-w

 

[alansidman]

How about

ActiveWorkbook.RefreshAll