I have a workbook with a couple of drop down lists. They are done with data validation of a named range.

Data validation settings are Allow: list. Source: =Client. Which is a valid named range when I look it up. Ignore blank and In-cell drop down are both checked.

There are actually 2 different data validation settings in 2 different columns based on 2 different named ranges and neither are working. It still validates the data, as it doesn't let me enter stuff that isn't on the list, but the drop down boxes are just not showing up.

It was working fine until a couple of days ago. I did have some frozen panes which I read can be a problem. I removed all of those, saved, closed, reopened but still not working.

Anyone have any ideas?