Hi All,

I have one workbook that is going to be my master workbook. I have many other files that i am trying to link all of the data from. What i am trying to do is update the master sheet even when all of the other workbooks are not open. I know excel doesn't do this normally, but is there someway to make it follow the domain it shows in the formula box to the non open file and read the data off of it. Thanks for all of the help.