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

Combo box 0
Data Validation List Disappears 0
problems when removing validation 1
Data Validation List: Text Size Query 2
2007 data validation not working 1
drop box/data validation help 0
Data validation 10
Data Validation Query 3

Top