Excel 2003 functions no differently than 2002 with respect to using named ranges
from other sheets for a DV list source.

Check your range-naming method. Is the named range really called "ListName"?

In source sheet select the range and InsertNameDefine....give it a name

In Target sheet DVSource enter =myname

Make sure spelling is correct.


Gord Dibben MS Excel MVP


On Tue, 16 Oct 2007 11:13:01 -0700, ClaireView
wrote:

I have a Data Validation list. I want to populate my drop-down list from a
different worksheet. I named the range, and for Source for the validation
list I typed =ListName. I STILL get an error message that I can't refer to
other Worksheets or Workbooks.

It's driving me crazy because this worked before! We updated from Excel
2002 to Excel 2003, so maybe that's why I'm having this problem. If so, this
is hardly an improvement! Also, is anyone else finding Microsoft's "help"
documents less and less helpful?