Hello,

I am trying to update links in another workbook (without opening the workbook) on the network by running the macro in the Active Workbook (This workbook is open and has the button to run the macro).

I found below mentioned codes, but getting a compile error:

Sub RefreshData()
Workbook("ANOTHER WORKBOOK.xlsx").UpdateLink Name:="\\Server\Drive\User\Folder\ANOTHER WORKBOOK.xlsx", Type:=xlExcelLinks
mdteScheduledTime = Now + TimeSerial(0, 3, 0)
Application.OnTime mdteScheduledTime, "RefreshData"
End Sub

The links which I am trying to update are Cell to Cell links (these links are not related to Active Workbook)

Kindly help me correct it.

Thanks loads.