See Debra Dalgleish's excellent article at
http://www.contextures.com/xlDataVal05.html
--
Pl click the YES button
(if you see it - don't worry if you don't),
if this answer was helpful.
"Alan Lindner" wrote:
How do you assign anohter Excel file as the source for the pulldown list?