Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Data Validation not working in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-02-2012
Member
 
Join Date: Oct 2011
Posts: 73
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.

Reply With Quote
  #2  
Old 09-02-2012
Member
 
Join Date: Aug 2011
Posts: 557
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
Reply With Quote
  #3  
Old 09-02-2012
Member
 
Join Date: Aug 2011
Posts: 454
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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Data Validation not working in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
How to convert monthly data into quarterly data in Microsoft Excel Glasney MS Office Support 4 04-01-2014 09:47 AM
Extracting data from Microsoft Project 2010 to Microsoft Excel Lennon Norris Microsoft Project 6 03-03-2012 03:35 PM
Data validation and Auto-complete help on Microsoft Excel ashwin2012 MS Office Support 2 24-01-2012 06:43 PM
How to check data validation compatibility of excel 2010 on excel 2007 Zoello Windows Software 6 17-05-2011 10:00 PM


All times are GMT +5.5. The time now is 05:17 AM.