Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    External source for dropdown list (2002/2003/2007)

    We are trying to follow the help instructions for creating an external (separate workbook) data source for a drop-down list:

    Use a different worksheet in a different workbook Type the list on that worksheet, and then define a name with an external reference to the list.

    Open the workbook that contains the list of drop-down entries.
    Open the workbook where you want to validate cells, point to Name on the Insert menu, and then click Define.
    In the Names in workbook box, type the name, for example, ValidDepts.
    Accept the default value in the Refers to: box, and then click OK.
    In the Refers to box, delete the contents, and keep the insertion pointer in the box.
    On the Window menu, click the name of the workbook that contains the list of drop-down entries, and then click the worksheet that contains the list.
    Select the cells containing the list.
    In the Define Name dialog box, click Add, and then click Close.

    But when we try to go to the Window menu for the Refers to, the Window menu list of open workbooks is gray. We try to type in the Refer to as "=ValidDepts" but then get a message that you cannot refer to an external list.

    There is probably one little step that we are missing, but we are lost. Any thoughts?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: External source for dropdown list (2002/2003/2007)

    The directions you list work for me in XL2002...

    if nothing else, you can enter in the worksheet for tha validation list an equal, then "On the Window menu, click the name of the workbook that contains the list of drop-down entries, and then click the worksheet that contains the list. Select the cells containing the list. " This will put in the cell something like:
    <pre>=[Book1.xls]Sheet1!$A$1:$A$5</pre>


    You can then copy this trext to the "refers to" in the name - define box.

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: External source for dropdown list (2002/2003/2007)

    Also see <post:=757,478>post 757,478</post:>.

Posting Permissions

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