Linking Names to Closed Workbooks

Hello,

I just spent the entire morning linking these two workbooks together. I've named some cells in the source workbook, and linked these names to the destination workbook. Then I used the names in some formulas in the destination workbook, and it worked great. But when I closed the source workbook it doesnt work. WHen I open the source it works great, but I need for it to be able to link to the workbook when it is closed as well. Does anyone know what I am missing? thanks for your help.