I have several spreadsheets that I want to reference defined names from one spreadsheet. The lists are for two drop down columns with column A just a list and column B has data validation using the indirect function dependent on what is selected from the drop down in column A. Everything works as wanted in the first spreadsheet "define name" refers to(=NAME1!$V$4:$V$20). However, when I use the 3-D reference and change the "refers to" (NAME1:NAME15!$V$4:$V$20) in the first spreadsheet neither drop down works on any spreadsheet? Help!