Drop Down List Error

R

rollthbns

I am trying to create a drop down list with a named range from an external
workbook. The directions in help work fine up until defining the named range
in validation under the data menu. It then tells me I cant use an external
workbook. I think I followed the directions exactly as outlined in the Help
area. Anyone have an idea what might be the problem? Thanks!
 
B

Bob Phillips

It is the way Excel works, Data Validation cannot refer to another workbook,
another worksheet yes, but not workbook.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top