Sorry, it works with another worksheet, but not another, closed workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tjb" wrote in message
...
I'm trying to get this to work but it's not going through. The range is
located on a sheet in a workbook located on a SharePoint server that will
be
accessed by all of my users. So the code I have in the validation looks
something like this:


=INDIRECT("http://sharepoint/Payroll/interim_data/interim_data.xls'!A1:A100"
)

"Bob Phillips" wrote:

You can use a named range or the INDIRECT function
(=INDIRECT("Sheet8!A1:A10")) to refer to a range on another sheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tjb" wrote in message
...
OK I need an in-cell drop down (or even a combo box would do...) with
values
populated from another workbook that resides on a public server.

Using validation only lets me have an in-cell drop down list with
values
populated from a range of cells on the same sheet in the same
workbook.

Basically, what I'm doing is my users will have the sheet with the
in-cell
drop down list and I want to dynamically control what they see in
their
drop
down list. I can dynamically control a VLOOKUP using this method but
not
their lookup value for the VLOOKUP.