| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation dropdown: works in one sheet, not in another
I defined a pulldown validation list in Sheet3.
I inserted the reference to the list in Sheet1 and it works fine. I inserted the reference to the list in Sheet2 and I'm told "the source currently evaluates to an error". The formatting of the relevant cells in Sheet1 and Sheet2 is identical. Sheet and workbook protection is off in all sheets. Yes, I used the "=" (=ThruList). Can anyone tell me why it works in one sheet and not the other? ---Pat Riley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create Dropdown lists not using Data Validation | Excel Discussion (Misc queries) | |||
| Trouble With Data Validation And Filtering On A Dropdown | Excel Worksheet Functions | |||
| size of data validation dropdown list | Excel Worksheet Functions | |||
| Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
| how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
Threaded Mode
