Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Durham, North Carolina, USA
    Posts
    140
    Thanks
    5
    Thanked 1 Time in 1 Post

    Data Validation list in another workbook (Excel 2002)

    Hi everyone,

    My users have several workbooks on which they want validated data. All of the books will use the same list, which they want in yet another book. The Data Validation dialog won't let me do this (the error says you "may not use references to other worksheets or workbooks for Data Validation criteria").

    I searched on the topic here in the Lounge and several people said they're doing this...but no one mentioned how! Would one of y'all mind leeting me in on the secret?

    TIA,

    Beej

  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: Data Validation list in another workbook (Excel 2002)

    Create a named range (insert- name -define) which references a range on another sheet (even in a another workbook). use this as the source for the list in the datavalidation.

    Note: the workbook must be opened for the validation to read the list.

    Steve

Posting Permissions

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