I created a SQL script, that eventually spools an Excel file.

This spool file is the source file for a total report (destination file) in Excel. I already tried to work with links between the source file and the destination file, but when I than open the destination file, it can only updates the values if I also open the source file. This is not what I want. I would like the destination file to automatically updates its value automatically wihtout having to open the source file. Can I record a marco to do this? If so, can anyone explain how?