Why is my data validation list not working?

Eugene Gerber

unread,
Apr 22, 2008, 9:56:47 PM4/22/08
to
I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook. It is working on all other sheets.

I have googled the problem and found the following advice:

1. Make sure freeze panes is off.... check.
2. Select "Show All" under Tools->Options->View->Objects ... check.

The problem remains. Any ideas?