Validate criteria in another workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ERuane - 08 Apr 2004 15:11 GMT

I am running excel 2003 XP. I am unable to validate criteria from on
workbook or worksheet to another. I get an error message "unable t
validate criteria from one workbook to another" At home I am able t
do this no problem. (office 97) I am able to validate criteria withi
the same worksheet only. I am trying to create drop down boxes using
common workbook. Please Help

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Frank Kabel - 08 Apr 2004 15:33 GMT

Hi
have a look at
http://www.contextures.com/xlDataVal05.html

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I am running excel 2003 XP. I am unable to validate criteria from

one

> workbook or worksheet to another. I get an error message "unable to
> validate criteria from one workbook to another" At home I am able to
> do this no problem. (office 97) I am able to validate criteria

within

> the same worksheet only. I am trying to create drop down boxes using

> common workbook. Please Help!
>
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

ERuane - 09 Apr 2004 20:27 GMT

Thanks - it worked

--
Message posted from http://www.ExcelForum.com

Reply to this Message