Hi Mac

For all versions of Excel, you have to name the list
(select list and enter name in "NameBox" (to the left
of the formula bar)). Use this name in the validation box.

The reason is, that Excel needs a *global* (not local) range
for a validation list.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"mac" skrev i en meddelelse
...
sHello,
I have excel 2003. I also have to 2 worksheets that look up the same list
in
data validation. It used to work in prior version, but I get the message
"May
not use reference to other workbooks or worksheets for Data Validation
criteria. Is there any way around this. Any help will be greatly
appreciated.
--
thank you mac