Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Files slow to open | Excel Discussion (Misc queries) | |||
Multiple Networked Files non-shared workbooks | Excel Discussion (Misc queries) | |||
updateLink; files with passwords , VBA help! | Excel Programming | |||
excel open files very slow | Excel Discussion (Misc queries) | |||
Excel Files Open Slow | New Users to Excel |