And If I link to a source list in another spreadsheet, I get an error.
If you use a named range/list, you can get it to work ..
Eg, in:
DV Settings tab
----------
Allow List
Source: =MyList
where MyList is a named range
refering to the DV items in say, Sheet2
For more info, try Debra's page at:
http://www.contextures.com/xlDataVal01.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"PRO1306" wrote:
What do I do when I wan't to use validation from a list, but I do not want
the list to be visible on the spreadsheet?
If I hide the rows containing the list, the hidden values also becomes
hidden in the list.
And If I link to a source list in another spreadsheet, I get an error.