Results 1 to 3 of 3

Thread: Data Validation not working in Microsoft Excel

  1. #1
    Join Date
    Oct 2011

    Data Validation not working in Microsoft Excel

    I have a worksheet that includes a /lot/ of data validation cells. There is one particular range of data validation cells (A29:A38) where we have identified a problem. We have not yet determined if this same problem will affect the rest of the workbook, or our overall project. The target range cells have data validation enabled: Allow: List. Source: =Positions (a named range from a hidden sheet). Ignore blank and In-cell dropdown are both checked. There is no input message Error Alert: Stop; and "Show error alert after invalid data" is checked.

    When the cell is selected, the dropdown arrow appears, and the list contains the expected entries, and they can be selected as expected. However, what we just found out is that users can type (not copy or autofill, really type) a non-list item into these cells and it doesn't trigger the error alert or prevent the entry. So, now we are getting invalid data trickling back into our data aggregation tables.

    I tried the instructions to "Find all cells with data validation". Using both 'Go to special' all and same, and it appears to be highlighting the correct cells (which is most of the worksheet for 'all') So that verifies that Excel thinks these cells have data validation, but leaves me with no other clues as to why the data validation isn't working. I can type random gibberish into those data validation cells, and it never throws an error.

  2. #2
    Join Date
    Aug 2011

    Re: Data Validation not working in Microsoft Excel

    I think you might need some better reference to make this work. Below link will provide you more detail on how to apply and work with Data validation in Microsoft Excel.
    Apply data validation to cells
    Description and examples of data validation in Excel

  3. #3
    Join Date
    Aug 2011

    Re: Data Validation not working in Microsoft Excel

    If you want to troubleshoot issues in Data Validation then the below link can be helpful. Basically there can be issue and you might need to check the below link to get easy info and fix.
    Troubleshoot data validation

Similar Threads

  1. Replies: 4
    Last Post: 04-01-2014, 09:47 AM
  2. Extracting data from Microsoft Project 2010 to Microsoft Excel
    By Lennon Norris in forum Microsoft Project
    Replies: 6
    Last Post: 03-03-2012, 03:35 PM
  3. Data validation and Auto-complete help on Microsoft Excel
    By ashwin2012 in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 06:43 PM
  4. Replies: 6
    Last Post: 17-05-2011, 10:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts