hello guys,

questions: to give an overview here's the scenario. i have 2 files before. both consists of headcount but in different perspective of days. first file is for 7days tenureship and the other is 30days. they both have summary tabs. now, what i did was move both of their summary tab in another workbook or should i say my 3rd file to combine my two summary tabs. so, in short i now have links. but whenever i close my first 2 data files, the formulas or values in my summary tab or in the 3rd file become values. i would like to know what should i do so that the link would automatically update the file even though the data files are not open?

Thanks in advance...