Put this in the workbook module:

Private Sub Workbook_Open()
    ThisWorkbook.RefreshAll
End Sub