Data validation

  • Thread starter Thread starter Matt Dalkie
  • Start date Start date
M

Matt Dalkie

I have a spreadsheet which does not appear to treat data validation
correctly. Adding a list validation with drop down list does not show
the drop down list, but the validation still works as entry is
restricted to the list. The problem occurs both for directly
referenced lists on the same sheet, or via named ranges on other
sheets.

From reviewing the group I've seen that other people have come across
this problem, but I've yet to find a solution. It's not caused by the
typical responses, i.e. Freeze Frames, Data>Validation>In-cell
dropdown or Options>View>Objects>Show all

Any help or ideas as always appreciated.

Matt

Win 2000Pro SP4
Office 2000Pro SP3
 
I've seen a little weird behavior with merged cells and data|validation.

Any chance you're cell is merged?
 
If you've checked for all the normal causes, and the problem still
occurs, the workbook may be corrupt. What happens if you copy the data
validation cells to another workbook?
 
Back
Top