| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation using named range from another file
I am setting up a list for cells. I am using data validation and
picking a named range. I have no issue if the range is in the active workbook. but i need to use a range from a different workbook. is that possible? if so how? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data validation using named range from another file
On 12 avr, 21:33, pat67 wrote:
I am setting up a list for cells. I am using data validation and picking a named range. I have no issue if the range is in the active workbook. but i need to use a range from a different workbook. is that possible? if so how? Thanks Hello, If you want to use a named range from a closed workbook, in a worksheet formula for example like average, you can enter your formula like this = average("[path to the closed workbook]\[closed workbook name].xls"! [name of the range] HTH |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data validation using named range from another file
On Apr 12, 6:36*pm, "
wrote: On 12 avr, 21:33, pat67 wrote: I am setting up a list for cells. I am using data validation and picking a named range. I have no issue if the range is in the active workbook. but i need to use a range from a different workbook. is that possible? if so how? Thanks Hello, If you want to use a named range from a closed workbook, in a worksheet formula for example like average, you can enter your formula like this = average("[path to the closed workbook]\[closed workbook name].xls"! [name of the range] HTH when i do that it says named range not found. but it exists. any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data validation using named range from another file
See Debra Dalgleish's site
http://www.contextures.on.ca/xlDataVal05.html NOTE: the source workbook must be open when selecting from the DV dropdown. Gord Dibben MS Excel MVP On Tue, 13 Apr 2010 06:08:52 -0700 (PDT), pat67 wrote: On Apr 12, 6:36*pm, " wrote: On 12 avr, 21:33, pat67 wrote: I am setting up a list for cells. I am using data validation and picking a named range. I have no issue if the range is in the active workbook. but i need to use a range from a different workbook. is that possible? if so how? Thanks Hello, If you want to use a named range from a closed workbook, in a worksheet formula for example like average, you can enter your formula like this = average("[path to the closed workbook]\[closed workbook name].xls"! [name of the range] HTH when i do that it says named range not found. but it exists. any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation List from a Dynamic Named Range on Another Workshe | Excel Worksheet Functions | |||
| Data Validation drop-down width, with named range source (XL03 and | Excel Worksheet Functions | |||
| Data validation drop downs don't recognize dynamic named range | Excel Discussion (Misc queries) | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Data validation named range update | Excel Discussion (Misc queries) | |||
Linear Mode
