+ Reply to Thread
Results 1 to 2 of 2

Data Validation - List option

  1. #1
    Registered User
    Join Date
    10-10-2016
    Location
    Ontario, Canada
    MS-Off Ver
    2010
    Posts
    1

    Data Validation - List option

    Hello guys, I am new to this forum and I have reading some really helpful information and tips.

    I have a workbook in which I have data validation in some cells (it has a drop down with a couple of options). After sharing the workbook with a collaborator, this functionality does not work anymore even when I re-do it (does not show drop down arrow, no options).

    But I can creat the same functionality in a new work book with no problem. Now, when I move the a sheet from the new workbook with this functionality (working) into the workbook that I had shared, the sheet looses the functionality (does not show the dropdown arrow and does not show the list of options).

    I am using office 2010 and I am not sure how to fix the work book. This workbook has a lot of sheets which are interconnected with formulas and will need to sometime to creat a new one.

    Thanks for your help.

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Data Validation - List option

    It would be easier for us to examine the problem if you could post a sample work book where the conditional formatting doesn't work. Just remove any sensitive data. Use the "Go Advanced" button at the bottom, and scroll down to the hyper link called "Manage Attachments".
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

+ 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. Data Validation List Option in Excel 2010..
    By suryatry26 in forum Excel General
    Replies: 7
    Last Post: 03-07-2014, 08:32 AM
  2. Data Validation list. Each selected option gives different score
    By jaywizz in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-15-2013, 11:57 AM
  3. Replies: 18
    Last Post: 09-18-2013, 10:29 AM
  4. Replies: 1
    Last Post: 06-19-2013, 07:02 PM
  5. How to Lock a cell based on option picked from a data validation list
    By dp0875 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-31-2013, 10:53 AM
  6. Use of conditions on Data validation LIST option
    By kannanr03 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 07-16-2012, 10:29 AM
  7. [SOLVED] Custom Option in Data Validation List
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2012, 06:18 PM
  8. Mouse scroll WITHIN a data validation list & option macro assistance
    By HOT97ECLIPSEGSX in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-11-2010, 11:11 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