Workbook B has links to Workbook A.

Workbook B has to be opened for the links to workbook A to be refreshed.

If you have workbook C that points at workbook B that depends on the links
getting refreshed, you'll either have to change the links in C to point at
Workbook A (or just open workbook b, refresh, save, and close).



GjArt wrote:

I would like to know how I can reference a range of cells in a closed
workbook, A, that may be updated daily, to cells in an open workbook, B, that
would be opened weekly. Would the weekly workbook, B, be updated daily
(while closed) from the daily workbook, A, or would (can) it update only when
opened each week?
I am referencing a yearly calander of vacation days, A, to a weekly work
schedule, B.

--

Dave Peterson