Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation problem...
Hi all
I have a workbook that has validations applied to it and it works great!!! I want to "change" the defined name in the source section to be a different defined name/range, but I get this message when I enter : "You may not use references to other worksheets or workbooks for Data Validation Criteria" I don't understand why it worked previously and why it doesn't work now. I created this template back in December - would an upgrade affect it??? Other information: To create the lists I used "defined names" as the lists are within another workbook - this is the only way to do this... To enter the defined name into the validation screen I used "name / paste"... Under TOOLS / OPTIONS / CALCULATION the option to Accept labels in formulas has been selected. The excel template is saved on a Network along with the datafile where the list lives. If anyone can shed some light on why I can't do what I was able to do previously please let me know asap. -- Thank for your help BeSmart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation | Excel Discussion (Misc queries) | |||
Data Validation problem | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) |