| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can 2 workbooks share data in Name Fields?
Hi,
I have 2 workbooks that use a common data source which is a worksheet loaded with name fields for validation lists. When I update some of the data source, I need to update it in two places... is there a good solution so they can share the data source with all the name fields? Any thoughts would be awesome! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can 2 workbooks share data in Name Fields?
Well, I thought I would answer my own question... I have figured it out.
Yes, they can. You must just name is properly using the Define Name field and refer to the other workbook. thanks, Mike "Mike R." wrote: Hi, I have 2 workbooks that use a common data source which is a worksheet loaded with name fields for validation lists. When I update some of the data source, I need to update it in two places... is there a good solution so they can share the data source with all the name fields? Any thoughts would be awesome! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| share and merge workbooks | Excel Discussion (Misc queries) | |||
| calculating populated fields from multiple workbooks | Excel Worksheet Functions | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| matching fields between two workbooks | Excel Worksheet Functions | |||
| matching key fields between two workbooks and displaying info when | Excel Worksheet Functions | |||
Linear Mode
