| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data validation works in one sheet but not another
I defined a pulldown data-validation menu in Sheet3.
I put a reference to it in Sheet1, and it worked OK. I put a reference to it in Sheet2, and it failed, telling me it evaluates to an error. Formatting of relevant cells is identical, sheet & workbook protection is (currently) off. Any reason why it would work in one sheet and not in another? ---PR |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation works in one sheet but not another
I"m not sure if the last post worked. I'm guessing you are trying to use a
list from Sheet2 on SHeet3. Take a look here and see if it helps. http://www.contextures.com/xlDataVal05.html HTH, Barb Reinhardt "Patrick Riley" wrote: I defined a pulldown data-validation menu in Sheet3. I put a reference to it in Sheet1, and it worked OK. I put a reference to it in Sheet2, and it failed, telling me it evaluates to an error. Formatting of relevant cells is identical, sheet & workbook protection is (currently) off. Any reason why it would work in one sheet and not in another? ---PR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| Data validation dropdown: works in one sheet, not in another | Excel Discussion (Misc queries) | |||
| Data Validation fromanother sheet | Excel Discussion (Misc queries) | |||
| combo box from data validation with source list in separate sheet | Excel Worksheet Functions | |||
| Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
Linear Mode
