Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Drop Down Lists | Excel Discussion (Misc queries) | |||
drop down lists | Excel Worksheet Functions |