drop list from a different workbook,

R

Ron de Bruin

Have you read this

For data validation to work, the workbook which contains the list must be open. You could create the list in a workbook that is
always open, but hidden, such as the Personal.xls workbook.
 
M

myquest

Yes, I tried creating a completely new workbook and keeping it open.
Same thing - I named the range with my list; I went to my first wrkbook and
defined a name using the other workbk name and then the name. Then at Data -
validation - source I put that name. I always get the same error.
 
M

myquest

You are quite right; If I use her exact range names and workbook name it
works but not with mine! I was using PartsBook.xls and the range name was
PartList. Very strange but I must be making a silly mistake - more coffee.
Thanks
 
Top