If the link is properly established, it should update. Since what you ask
is normal behavior if you have the proper settings and proper links, there
wouldn't be any special action which you would need to take or which you
could take.

--
Regards,
Tom Ogilvy

"zimon72" wrote in
message ...

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?


--
zimon72
------------------------------------------------------------------------
zimon72's Profile:
http://www.excelforum.com/member.php...o&userid=30592
View this thread: http://www.excelforum.com/showthread...hreadid=502842