| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Restriction Referencing other Workbook
Following procedure to link Data Validation list to another workbook -
dialogue box message appears "You may not use references to other worksheets or workbooks for data validation criteria". I am using Excel 2003. Any suggestions are greatly welcomed! Jim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Restriction Referencing other Workbook
Give your list a name, select the list and do insertnamedefine and type in
a name for instance MyList then use Allowlist =MyList -- Regards, Peo Sjoblom "Jim" wrote in message ... Following procedure to link Data Validation list to another workbook - dialogue box message appears "You may not use references to other worksheets or workbooks for data validation criteria". I am using Excel 2003. Any suggestions are greatly welcomed! Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a range on a different tab than where data validation | Excel Discussion (Misc queries) | |||
| Create formula referencing drop down list (data validation) | Excel Discussion (Misc queries) | |||
| Referencing a data validation list | Excel Discussion (Misc queries) | |||
| Data referencing and auto fill across worksheets in one workbook.. | Excel Worksheet Functions | |||
| Data Validation - Restriction | Excel Discussion (Misc queries) | |||
Linear Mode
