+ Reply to Thread
Results 1 to 2 of 2

Dependent Drop Down List only partially working

  1. #1
    Registered User
    Join Date
    09-27-2022
    Location
    Leeds, England
    MS-Off Ver
    Excel 2013
    Posts
    1

    Red face Dependent Drop Down List only partially working

    I have made a dependent drop down list which works as expected for my first two columns of options (in 'Schools' sheet) but for some reason does not work when selecting the third option of the initial list ('Cluster' column)

    When I tried altering the headings of the two columns that worked (ARM and EPOS) they stopped working, despite being selectable in the inital 'Cluster' column under their altered names.

    Googling and playing around has not availed me - any help very much appreciated. I've changed the names of the schools to random strings for confidentiality.

    Annotation 2022-09-27 102032.png
    Annotation 2022-09-27 102058.png
    Annotation 2022-09-27 102116.png

    Thank you!
    Attached Files Attached Files
    Last edited by anything12378; 09-27-2022 at 10:30 AM.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Dependent Drop Down List only partially working

    Check Name manager, names must start with a letter or _, in your name manager you have it with an underscore however in the Schools table it doesnt match to that.

    You'll need to either change the name of 2Gether so that it starts alpha or add the _ to the column heading in Schools and reset the Name manager to show the right data
    If someone has helped you then please add to their Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 07-18-2021, 06:31 PM
  2. Replies: 6
    Last Post: 01-07-2021, 12:05 PM
  3. Dependent drop down list. Why is INDIRECT formula not working.
    By TRAZ6666 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2020, 07:15 AM
  4. dependent drop down list not working as it should
    By K-Ching in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2015, 02:58 AM
  5. [SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE
    By ginieman in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-28-2013, 03:56 AM
  6. [SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list
    By ptmald in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 07:17 PM
  7. [SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE (e.g. Blank)
    By Waqar Ali in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-26-2012, 06:31 AM

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