If you can avoid it, then avoid linked files. Better to have one large
file than 3 linked ones.

What formulae are you using? =indirect() only works on opened files

Is your linked file (son) also linked to another file (grandson)? If
so then you need to update these source links (as well as any earlier
links) before updating the final links.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533982