drop down lists
 

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

drop down lists
 

Recollect a Bob Phillips' post to try "Open and Repair" in XL2003. Click File
Open, navigate to folder, select the file, then click the arrow dropdown on
the right of the "Open" button choose "Open and Repair". Good luck !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tony" wrote:
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