Slow Updatelink off Networked Open files

H

h2fcell

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.
 

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

Similar Threads

Macro to Update links on a network 4
Macro To Avoid Link Update of Open Files 3
Run-time error 1004: Method 'UpdateLink' 2
Code to update links every 30 seconds 1
RUNTIME 1004 3
Excel - PowerPoint linking Problem 0
Limiting files to open to only files with certain name. 10
Opening another workbook and then closing it. 2

Top