One of a way to do is go to Edit in worksheet menu bar, click on Links
then select a source whose path has changed now and click on
commandbutton "Change Source"...Now select the new path and file and
set it as source. I believe this will work, as it worked on my
system.

I hope this helps...

Selva V Pasupathy
For more on Excel, VBA, & other Resources
Please visit: http://socko.wordpress.com