Bobby,

It might be easier to Edit your Links. In 2010 go to Data Edit Links and select the file name that is changing. Then click "Change Source" and browse to the new file name. This will change the file reference throughout the workbook.

Ben