Hello,

I am looking to write a macro to update the links in a shared workbook on a shared network.

Some background: The shared file that I wish to have the macro in is a file that contains links to 9 other files, all on the same shared network. This shared file basically sums up forecast data in each of the 9 sheets. I want to be able to update the links at anytime if any changes have been made to any of the 9 other files. How would I write this?