External excel file as a query database

Is it possible to connect in Spreadsheet an external .xls or .csv file as a query as well as in Excel (that when I update the external excel file automatically update in spreadsheet worksheet)?
Thank you

I have not tried it out yet - however I have the feeling this may work :