I have a spreadsheet that uses drop down lists of names and other data using
Name,Define and Validation ofthe lists. This has worked fine for months and
then all the drop downs disappeared and I cannot get the spreadsheet to
accept them when I attempt to re input them - all the reference information
is still there in the same places.

Anyone any idea how/why they disappeared in the first place or why I cannot
redo them?
--

Thanks Frustrated Tony