Macro to update linked formulas

[Ludovico]

I have a rollup spreadsheet with formulas linking to many other Excel spreadsheets residing on a corporate network. It seems that often I have to open the source spreadsheets or close and then re-open the rollup spreadsheet to get the data in the rollup to update. Is it possible to create a macro which would update all of the links without having to open/close any files so I could always be sure I have the latest information showing in the rollup?
Thanks,
Ludovico

 

[kskinne]

Ludovico,

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

will update all links in the active workbook, you could put this in a sub and assign a command to it, or you could make it part of a workbook_change event so it updated your links each time a change was made to your workbook, just depends on what you want to do.

HTH
kevin

 

[Ludovico]

Great. I really appreciate your help!
Ludovico