| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
external refs and dropdown validation
Thanks very much all.
"Harlan Grove" wrote: NJS wrote... When I follow the steps to create a dropdown based on a list in another workbook I get "You may not use references to other workbooks for Data Validation"? Does this mean what it says, and is it not possible to use another workbook as the source? I noticed some discussion between Michael and Massi, but this didn't answer the primary question? For my own convenience I'll refer to the workbook in which you want to use a data validation list as A and the other workbook containing the data you want the list to display as B. If B were OPEN and you had defined a name in A referring to the range in B that you want to use as the list source, you could set the data validation list to refer to =YourDefinedNameHere. So, given these caveats, you can use references into other workbooks. OTOH, it's not possible to use direct references into CLOSED workbooks. In such cases, your options are limited to filling a range in A with the values from B, then use that range as the list source. If I am obliged to refer to a local list linked to an external source, does this not significantly increase the size of the local workbook? Depends on how much data you'd be fetching from B. If A would be a few megabytes in size without the linked data, and the linked data added less than, say, 250KB to the file size, that'd seem reasonable to me, but this is subjective. OTOH, if your linked data would double the file size or more, you need to reconsider your design. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Closed External Refs | Excel Discussion (Misc queries) | |||
| Validation-dropdown | Excel Discussion (Misc queries) | |||
| Multiselect Validation (dropdown) | Excel Discussion (Misc queries) | |||
| In-Cell Dropdown for validation not displaying | Excel Discussion (Misc queries) | |||
| dropdown with validation?? | Excel Worksheet Functions | |||
Threaded Mode
