Visit Debra Dalgleish's site:
http://contextures.com/xlDataVal05.html



ssGuru wrote:

What choices do we have to get around Excel's refusal to use a remote
workBOOK for cell data entry validation?

No problem to use another internal workSHEET when the range is named
but can't use an EXTERNAL workbook.

Could I perhaps use an internal hidden worksheet that obtained its
data from a remote workbook?
Still working on solutions.

Any ideas would be appreciated.

Dennis

--

Dave Peterson