+ Reply to Thread
Results 1 to 4 of 4

Remote Dynamic Lists for Drop Down Boxes

  1. #1
    Registered User
    Join Date
    11-14-2011
    Location
    England,North East
    MS-Off Ver
    Excel 2003
    Posts
    67

    Remote Dynamic Lists for Drop Down Boxes

    Hi, I'm hoping someone can help here as I'm driving myself slowly mad with this one. I have created a dynamic list called Employees in a workbook called MyLists and I am trying to use this as data for a drop down box in a separate workbook call Schedule. In Schedule I have Defined the list as follows:

    Names in Workbook:MyLists
    Refers to = MyLists.xls!Employees

    I have then in data validation put list and then:

    Validation Source = INDIRECT("[MyLists.xls]Employees")

    but all that happens is that I keep getting an error that says

    Error=The source currently evaluates to an error. Do you wish to continue?

    I have attached the workbooks that I am trying to work this out on. All help very gratefully recieved. Did I mention that I'm going slowly mad with this!

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Remote Dynamic Lists for Drop Down Boxes

    Hi

    Really don't understand, why you need INDIRECT in this case.......
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    11-14-2011
    Location
    England,North East
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Remote Dynamic Lists for Drop Down Boxes

    To be honest Fotis I have no idea, I'm just copying from an Excel online workshop. All I am trying to do is create a master data workbook that I can then use as reference for multiple user workbooks with regards to lookups and drop down lists. I've managed to sort out the macros for triggering the master data book to open when any of the other workbooks is opened but I'm having trouble with defining the drop down list validations so have turned to the net for inspiration.

    Is there a better way?

  4. #4
    Valued Forum Contributor
    Join Date
    12-05-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    308

    Re: Remote Dynamic Lists for Drop Down Boxes

    Hi there.

    Do you have both workbooks open at the time you're doing the drop down?

    As an aside, and I realise this is a work around, not the exact solution you originally asked for, have you considered using a Query to load the data in to your spreadsheet when it is opened? You can then have another dynamic range in this workbook. Of course, it does bloat your workbook a bit.

    Regards, Rob.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1