+ Reply to Thread
Results 1 to 2 of 2

In Data Validation List (2007) in one workbook only: In cell dropdown not showing?!

  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    In Data Validation List (2007) in one workbook only: In cell dropdown not showing?!

    I have the checkbox for in cell dropdown checked (in data validation)
    There are multiple sheets that have data validation lists in this workbook - none of them show the dropdown. If you try to input wrong info - you get the error.
    I have another workbook that has data validation - working like a charm.

    There has to be some setting for this workbook that I inadvertantly turned on or off.

    Does this sound familiar to anybody?
    Last edited by CRIMEDOG; 10-11-2010 at 06:18 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: In Data Validation List (2007) in one workbook only: In cell dropdown not showing

    Solved:
    Excel Options
    Advanced
    Display Options for this workbook
    For Objects Show:
    [All]

+ 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