software

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!
--
fate is just the weight of circumstances

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)

quot;rollthbnsquot; gt; wrote in message
...
gt; I am trying to create a drop down list with a named range from an external
gt; workbook. The directions in help work fine up until defining the named
range
gt; in validation under the data menu. It then tells me I cant use an
external
gt; workbook. I think I followed the directions exactly as outlined in the
Help
gt; area. Anyone have an idea what might be the problem? Thanks!
gt; --
gt; fate is just the weight of circumstances
I haven't tried data validation using a named range from another workbook,
but this site discusses it:

www.contextures.on.ca/xlDataVal05.html

The site helped me while I was trying to use a named range from another
worksheet.

--
Kevin Vaughnquot;rollthbnsquot; wrote:

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