the linked file needs to be opened

run the maco recorder and open the file
then insert this code in the workbook open event,
so whenever the main workbook opens, it will open the other workbok as
well,
search your forum and search for open workbooks when opening an excel
file,
or opening workbooks in open workbook event, its done all the time.
there are ways to link files to a closed workbook, but that takes a
while to explain, If you really want to do that then search your forum,
for linking closed workbooks


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519573