Power Query dont update

Originally Posted by alansidman

Private Sub Workbook_Open()
ActiveWorkbook.RefreshAll
End Sub

or

Clcik on Queries and Connections

Select Properties and then check the box highlighted in the picture

I will try to use vba