Updating Separate Workbook References

[hyattj]

I have a summary page that references a bunch of other workbooks where all my real work is conducted. Each workbook represents a certain stock contract for a certain month, and a certain year. On those workbooks I have a program (Reuters) that draws in data daily. Problem is everything is based off dates so on my summary page i have a cell where a date is inserted, then all the vlookup formulas i have on my summary page refer to the other workbooks based on that date. I want to have it where when i open up my summary page to update values, it also updates the values in all the workbooks being referenced on the page. I dont know if this can be done through settings, my boss just doesn't want to have to open up all the separate worksheets. Let me know if anyone has any suggestions.

-Jake

[ARGK]

Hi Jake
If you have bi-directional links between multiple workbooks then the updates should be done automatically whether the workbooks are all open or not. The only stipulation is that they are all on the same network structure and they are never moved, otherwise the links will break.
Hope this helps.
Kind regards
Tony