Dear Sir,

When you link a workbook Excel needs the File Name, The Sheet Name and
the Cell Name. When you drag the formula Excel will keep exactly the
same reference. However, if all the linked files are in the same
folder and the information is contained in sheets named the same and,
same cell reference you will only need to update the File Name part of
the new references.

Regards

Juan Carlos


--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=376376