i am trying to link a destination workbook to several different source workbooks. The formula's that I've entered are correct (I've had other people check them to be sure). The problem occurs when I open my workbook and click update values. The numbers then all change to #value. I can get the values to go away if I click edit, links, open source. Once the source is open the value errors go away and the correct information is entered. Why do I have to open the source workbooks and is there a way around this?? PLEASE HELP..