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.