+ Reply to Thread
Results 1 to 10 of 10

Drop down list not working

  1. #1
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Drop down list not working

    Hi,

    I have a drop down list which is auto updating from a table.
    It works fine when the source data and drop down list are on the same sheet, but its not updating when the source data and drop down list are on different sheets

    What am I missing?

    Thanks
    Kevin

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Drop down list not working

    if you copied it over, when you look at the format control the input range has to change to reference the original sheet, otherwise it will simply reference the new sheet range.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Drop down list not working

    Hi Sam,

    Thank you for looking, that does not appear to be the issue? its references the correct sheet
    i have just tried again in a new workbook and the same problem exists?

    Thanks
    Kevin

  4. #4
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Drop down list not working

    Hi Excelski.

    Save the drop down list as a "Named Range" and the list will then be available to all sheets without having to reference the sheet name/number in any formulas or Data Validation (lists).

    Regards

    peterrc

  5. #5
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Drop down list not working

    Hi Peterrc

    I have tried that too.
    I can create a drop down using a named range which updates as items are added to the list, but I can not do it with the data and the drop down on different sheets.
    I must be missing something simple?

    Thanks for looking
    Kevin

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Drop down list not working

    is it just this particular workbook or is does it happen with other workbooks? Can you upload the workbook?

  7. #7
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Drop down list not working

    its happening on all workbooks and on different excel versions, i must be doing something very basic wrong... repeatedly!!
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Drop down list not working

    Hi Excelski,

    You had the Table Name as Nameslist
    and the Named Range as Nameslist.
    I've changed this (see attached) and it is now working.
    Please note I have used "=Names" in the Data Validation.

    Regards

    peterrc
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Drop down list not working

    Hi peterrc,

    I couldn't see the woods for the trees!
    Thank you

    Regards
    Kevin

  10. #10
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Drop down list not working

    Hi Excelski,

    Happy to help!

    Regards

    peterrc

+ 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. drop down list working by magic
    By wawilson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2017, 02:46 PM
  2. Drop List Zoom Program Not Working
    By pahickham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2017, 10:29 AM
  3. Drop List Program not working.
    By pahickham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2017, 02:42 PM
  4. drop down list not working
    By hek in forum Excel General
    Replies: 4
    Last Post: 03-05-2016, 03:44 AM
  5. 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:59 AM
  6. 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
  7. Indirect drop down list not working
    By Narelles in forum Excel General
    Replies: 3
    Last Post: 12-18-2013, 09:16 PM

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