Data Validation Error

C

CH

I have a spreadsheet with multiple drop down selection boxes setup using Data
Validation, which all reference different lists.

The problem I have is that one of the dropdown arrows for the validation box
is always visable even when the cell is not selected. For the dropdown to
work properly, the cell must be selected.

I've tried clearing and resetting the Data Validation for this cell, but the
dropdown arrow always remains (even when the validation is completely cleared
off).

Any thoughts on what might be causing this, or how to fix?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Dropdown Error - What am I missing? Seems like an 2
Data Validation Dropdown List Not Working 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List: Text Size Query 2
problems when removing validation 1
Data validation 10
Data Validation & multiple columns 1
2007 data validation not working 1

Top