If I am understanding your question correctly, then when changing links,
you should be prompted when re-openning the file to "Update Links" (yes,
no).


--
wmaughan
------------------------------------------------------------------------
wmaughan's Profile: http://www.excelforum.com/member.php...o&userid=29743
View this thread: http://www.excelforum.com/showthread...hreadid=493284