Hello! This is my first post. I am urgently doing something and because I'm not smart enough, I can't seem to come up with the solution.

I was hoping if anyone could help me.

Right now, I have multiple workbooks (summary, 2003, 2004, 2005, ..., 2015).

There's this "weight" cell in summary workbook. If both summary and 2003 workbooks are opened, and I change this weight cell to a different #, the 2003 workbook re-calculates it's values, and summary workbook also updates based on the re-calculation in 2003. So it auto updates using the weight.

If 2003 workbook is closed, and I change this weight cell in summary workbook, I cannot see the automatic update. Nothing happens. Because I need this relationship to work between summary and 2003, summary and 2004, summary and 2005, and so on...for now I MUST leave open each and every workbooks from 2003 to 2015 in order for summary page to take effect the modified weight.

Is there a way to leave 2003 to 2015 workbooks all closed, and the summary workbook do it's magic?

I hope I was clear with the question.

Thanks for reading!