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
Thanks,
Ludovico