+ Reply to Thread
Results 1 to 2 of 2

Drop Down Lists Stopped Working

  1. #1
    Registered User
    Join Date
    12-08-2011
    Location
    idaho
    MS-Off Ver
    Excel 2010
    Posts
    8

    Drop Down Lists Stopped Working

    I have a workbook with a couple of drop down lists. They are done with data validation of a named range.

    Data validation settings are Allow: list. Source: =Client. Which is a valid named range when I look it up. Ignore blank and In-cell drop down are both checked.

    There are actually 2 different data validation settings in 2 different columns based on 2 different named ranges and neither are working. It still validates the data, as it doesn't let me enter stuff that isn't on the list, but the drop down boxes are just not showing up.

    It was working fine until a couple of days ago. I did have some frozen panes which I read can be a problem. I removed all of those, saved, closed, reopened but still not working.

    Anyone have any ideas?

  2. #2
    Registered User
    Join Date
    12-08-2011
    Location
    idaho
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Drop Down Lists Stopped Working

    Never mind, I figured it out. My "show all objects" check box wasn't checked in my Advanced options.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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