Items in Drop down are all wrong!

I have an excel sheet with drop downs for filtering. Only some display the correct item. But for every other row or column I go in, the drop down says the same thing when it should have choices. Where do I begin to even see how the drop downs are setup?

first, upload please your wb.

sorry I cannot, as it contains HIPPA information. It is weird, all but some boxes are diplaying one term, when there should be different ones in the box for each section but have no idea how to even check it. I tried data validation but nothing really changed

Originally Posted by Richard Buttrey

Sanitise your data, or delete any sensitive stuff so that it displays the same problem, then upload.

Ok I did, no customer/client info is displayedCriteria Form.xlsx
IT says "high" in areas it should not.

Check all of your Data Validation statements - it does look like the source cells are off, one shows a typed list in the "Source," but most show a cell reference. "High" is coming from cell $N$12. These things happen to me when I move to a cell instead of using enter.

Originally Posted by johnnymac

Check all of your Data Validation statements - it does look like the source cells are off, one shows a typed list in the "Source," but most show a cell reference. "High" is coming from cell $N$12. These things happen to me when I move to a cell instead of using enter.

I have no idea how to check all data validation statements. I am not the excel/spreadsheet guy here, I was just given this. I will try that, but have no idea how to do so, really. I clicked the data validation tool earlier and nothing changed, but again I am not familiar with this so easy to understand instruction would be great if possible.

When you open the data validation there will be the option for Source, this should be a comma separated list as it is in some of your cells, or a cell reference which can be a range of cells. If you correct these cells ranges to the appropriate lists, this will work.

DataValidation.gif