The second part of your post shouldn't be too hard to address. Once you get
the workbooks open on your machine you should be able to see the bad link
under Edit, Links. You can select it in the list of linked files, choose
"Change Source" and point to the correct file location.

The first part... You could go the Edit, Links, Change Source route with
each dependent workbook but an easier way is to have all the dependent
workbook open in Excel, along with the source workbook, when you do a File,
Save of the source workbook to its new name. Then all the links will be
updated automatically by Excel. You'd have to save them all after that of
course...

--
Jim Rech
Excel MVP