Results 1 to 2 of 2

Thread: Range Name in Data Validation not working

  1. #1
    Neophyte Heinrichdp's Avatar
    Join Date
    Nov 2019
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Range Name in Data Validation not working



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm trying to create a dynamic drop down list in excel 2016 using Data Validation.

    I created Named Tables containing the list details.

    I entered the list name in the Data Validation section, but it does not want to except it?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Range Name Error.jpg 
Views:	7 
Size:	94.0 KB 
ID:	9462  

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,287
    Articles
    0
    Excel Version
    Office 365 Subscription
    You'll need to create a named range based on the table range - a bit counter-intuitive, but should work.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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