| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to refenence ranges on a closed workbook
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
| INDIRECT and Named Ranges referencing closed workbook | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
