drop down lists

T

Tony

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?
 
M

Max

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
Click to expand...
the right of the "Open" button > choose "Open and Repair". Good luck !

---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with drop down lists 1
Drop down list ???? 1
Data Validation & Drop-Down Lists 4
drop-down lists 2
How to create 2 dependent drop down lists from 1 original drop dow 5
Drop-down Delete Multiples 1
drop down lists 1
Linking Excel drop down lists 2

Top