View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
PRO1306 PRO1306 is offline
external usenet poster
 
Posts: 1
Default Place source to drop down list in another spreadsheet

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.