Place source to drop down list in another spreadsheet

PRO1306 · External Since: Jun 15, 2007 Posts: 1

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.

Gary''s Student · External Since: Oct 01, 2005 Posts: 3200

Don't hide the column with the validation list. Set the font color of the
items in that column to the same as the color of the cell. In the column the
list will be invisible, in the dropdown the list will still be visible.
--
Gary''s Student - gsnu200729

Max · External Since: Mar 17, 2004 Posts: 1619

> 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.
>
>