Excel will not automatically refresh external data on open
 

I have created a data source using Microsoft text driver and it works fine on
manual refresh. However, I cannot get it to refresh data automatically on
opening the workbook. I have checked 'Refresh data file on open' in External
Data Range Properties and 'Save query definition' is also checked. Is there
something I'm missing? Any advice would be much appreciated. Thanks.