Data Validation List Not Showing

T

The Project Master

Hello. I am hoping someone can assist me. In Excel 2003, I have a cell
where I
had created a data validation list. I selected "List" in the Allow box, I
checked
the "In-cell dropdown" and I entered the values (3,5,7,10) directly into the
"Source"
box and I had created an input message that appeared when the cell was
selected.

Everything was working fine until this morning when I opened up the
spreadsheet.
Now when I select the cell I get the input message that I created but the down
arrow button does not appear with the values. When I go to Data>Validation
"List"
appears in the Allow box, the "In Cell Dropdown" box is checked and the values
are in the source box, so it appears everthing is fine from a setup
perspective.
The is no protection on the workbook. Has anyone every encountered this
before and found a solution? Thanks for your assitance.
 
T

The Project Master

Thank you Debra. Unfortunately, none of these solutions worked. Any other
thoughts? Thanks.
 

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

Top