Hello and greetings from South Texas (very cold). I've created a simple
spreadsheet report with six different categories (columns). In two of those
categories I implemented drop down lists using Data>Validation>List, etc.
Initially it worked like it was supposed to therefore giving me the luxury of
selecting different options from the drop down menu. I locked several cells
(not including the two columns) and protected the worksheet with a password.
As I opened the file this morning I deleted the current information in an
attempt to enter new information (expecting the drop down fields to be in
tact), but the drop down list has dissappeared. The list of information is
still located on page two, but the drop down is no longer there. I've tried
restarting, protecting/unprotecting, redoing the validation list, etc., but
to no avail. Sorry for the narrative. Can you help please?

John