Link query to Excel, then back to Access??

[Guest]

I recently used Excel to link an Access query as external data to an Excel
worksheet, then linked that file back to Access to use as a table. To me,
this was a workaround way of having query results as a table. I set the
Excel file up to auto-refresh every 60 minutes, but the linked Access table
(based on the Excel file) does not seem to be updating properly. I have no
need to ever open the Excel file, so I figured the auto-refresh would handle
this. Does the Excel file need to be open in order to auto-refresh?

 

[John Nurick]

This is an Excel question rather than an Access one, but in general
it's a pretty safe assumption that no file will do anything unless
something opens it!