I have a drop-down list that was working fine in Excel 2003. Then my computer
was upgraded to Excel 2007. And while, I like Excel 2007, there are some
quirks when working in a spreadsheet that originated in 2003 (or if other
people who have 2003 are using).

Here's my problem. The drop-down list that I created through Data
Validation, only shows the heading of the list when I click on the arrow to
select from the drop-down box. There are no other options available. But when
I right-click the cell and choose "Pick from drop-down list" from the
shortcut menu, it points to the correct list; but this setting doesn't stay
on the cell. If I click off the cell and click back on it, I still get only
the heading of the list in the drop-down list and start over again.

Any suggestions?
--
Thanks,
Beth