update links
 

Hi
i have a workbook cntain a large number of links to several workbooks
i am trying to update the links automatically
i am trying to do this using a date serial value
problem i have is if i loss focus on the workbook
ie another workbook or screen saver
the update links crashes
is there a way of getting the links to update in the background ?
or
for the focus to the workbook so the links will update
i am using
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
if i change active to this workbook will it work?

thanks

kevin