Why the link cannot be updated?

E

Eric

Does anyone have any suggestions on why the following files cannot be updated?
They can be updated before, without changing anything, when I run the list
again, it just open and close without updating the links and perform all the
updated calculation. I have checked the advance option to perform
automatically calculation on those worksheet.
Does anyone have any suggestion on how to solve this problem?
Thanks in advance for any suggestions
Eric

Sub Temp()
Application.DisplayAlerts = False

Workbooks.Open Filename:="C:\File1.xls", UpdateLinks:=3
Workbooks("File1.xls").Close savechanges:=True

Workbooks.Open Filename:="C:\File2.xls", UpdateLinks:=3
Workbooks("File2.xls").Close savechanges:=True

....

Workbooks("Update Files").Close savechanges:=True

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top