Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    validation list (2003)

    Hi all,

    Is there a way that we can refer data validation to list from another file/workbook?

    thanks and regards

    Indra

  2. #2
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: validation list (2003)

    Hi Indra

    I just tried to set up a list in one workbook closed it and then tried to reference it through data validation and the Mr. Clippy thing said that you cannot use data validation from another workbook so my guess would be No you can't, however, that being said you can bet your life that somebody else here will prove me wrong. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: validation list (2003)

    Ya Steve, I am hoping probably there are vba code to solve

    regards

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

    Re: validation list (2003)

    It is possible, but it will only work if the other workbook is open. If the workbook is closed, Excel cannot read the list. So it is not a good idea. You can use a list in another worksheet in the same workbook, though.

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

    Re: validation list (2003)

    You can do the following though:
    - Open the workbook with the list.
    - Select the list.
    - Select Edit | Copy.
    - Activate the workbook where you want to use validation.
    - Select a suitable cell.
    - Select Edit | Paste Special...
    - Select the 'Paste Link' option.
    - Click OK.

    The copy of the list will be updated automatically if the original list changes.
    You can use the local copy to act as list for validation.

Posting Permissions

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