how do i correct broken link in multiple Excel files
 

I had changed the location of the Xcel file that all my other excel files are
linked to due to certain errors. now i have 1000 files that are linked to
this file. how do i correct the broken link without having to open each and
every file. this will take me days to achieve if i have to do it this way.

Also i would like to change the page setup in each files, and each files
contain worksheets that also need corrected page setup. how do i do this en
masse