Links don't update unless the source file has been opened?

[badams]

When I open my worksheet and select update links I don't get any of the information. If I open the worksheet where the information resides then the information appears. The problem I have is the source file is large. Having to open it frequently is time consuming. Thanks for the help.

Bryce

 

[AgentSmith]

Depending on how much data you have linked, you could write the data you require from the source spreadsheet to a CSV file using the "Workbook_BeforeSave" or "Workbook_BeforeClose" event and link to the CSV file instead. Time taken to refresh should be pretty quick if there aren't many links.