Linking files together
 

I have created a macro to dump data from 12 different
queries in MS Access into 12 different Excel files. That
part works great.
I have another Excel file (in the same folder) that is
linked to each of these files. However, it will not read
the updated info in these files unless I manually open
each of the 12 files. What do I need to do to to make my
Excel file read the data from the 12 files without opening
each of the files?

Thank you.