Slow Updatelink off Networked Open files
 

Hello,
I have a file that updates links to seven other files on a network file
server.
While the seven files are closed the below "Refresh" sub works quickly,
maybe 5 seconds. If the seven files are open on separate PC's the refresh
takes longer, about 58 seconds.
Is there anything I can do to get the refresh back to 5 sec. or less while
the files are open?

Sub Refresh()

ActiveWorkbook.UpdateLink Name:= _
"Y:\Election\Ward 1.xlsm", Type:= _
xlExcelLinks
ActiveWorkbook.UpdateLink Name:= _
"Y:\Election\Ward 2.xlsm", Type:= _
xlExcelLinks
ActiveWorkbook.UpdateLink Name:= _
"Y:\Election\Ward 3.xlsm", Type:= _
xlExcelLinks
ActiveWorkbook.UpdateLink Name:= _
"Y:\Election\Ward 4.xlsm", Type:= _
xlExcelLinks
ActiveWorkbook.UpdateLink Name:= _
"Y:\Election\Ward 5.xlsm", Type:= _
xlExcelLinks
ActiveWorkbook.UpdateLink Name:= _
"Y:\Election\Ward 6.xlsm", Type:= _
xlExcelLinks
ActiveWorkbook.UpdateLink Name:= _
"Y:\Election\Ward 7.xlsm", Type:= _
xlExcelLinks

End Sub

Thanks for any help.