The purpose of updating links is so you don't have to open those other
workbooks.

If you run the code manually (just stepping through it with F8's), does it work
ok?

If it blows up there, I don't think it would be a timing issue.

DRK wrote:

I've tried the below code in ThisWorkbook in both Workbook_Activate() and
Workbook_Open()

ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources
or
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

Both throw a run-time error '1004'. Message is 'UpdateLink' of object
'_Workbook' failed.

The other workbook is not open yet. Is this the cause of the problem? If so
what can I do about it? Do I need to open them simultaneously? If so, how can
I do that?
--
DRK

--

Dave Peterson