 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Data Validation List not showing
I'm using Excel 2003. My data validation lists have stopped working on one sheet in my workbook. It is working on all other sheets. I have googled the problem and found the following advice: 1. Make sure freeze panes is off.... check. 2. Select "Show All" under Tools->Options->View->Objects ... check. The problem remains. Any ideas? "Stopped working" doesn't do much to describe your problem. When you select one of the "stopped working" Data Validation cells, do you see the drop-down arrow to the right of the cell? When you select this cell and do Data - Validation, what do you see in the Data Validation setup? HTH Otto > I'm using Excel 2003. My data validation lists have stopped working on one > sheet in my workbook. It is working on all other sheets. [quoted text clipped - 5 lines] > > The problem remains. Any ideas? By "Stop Working", I mean that the drop-down arrow has disappeared. The actualy validation still works though, because Excel doesn't allow me to type anything other than the list that I provided. When I select the cell and check the data validation options, everything seems okay. Allow is set to "list" and both tick boxes on the right are checked. > "Stopped working" doesn't do much to describe your problem. When you > select one of the "stopped working" Data Validation cells, do you see the [quoted text clipped - 10 lines] >> >> The problem remains. Any ideas? If you delete the data|validation from cell and add it back, does it work? If you delete the row with that cell on it and insert a new row and reapply data|validation, does it work? > By "Stop Working", I mean that the drop-down arrow has disappeared. The > actualy validation still works though, because Excel doesn't allow me to [quoted text clipped - 18 lines] > >> > >> The problem remains. Any ideas?  SignatureDave Peterson No to both your questions. The problem seems to be on the entire sheet. If I add validation to a cell that hasn't had it before, it also has the same problem. > If you delete the data|validation from cell and add it back, does it work? > > If you delete the row with that cell on it and insert a new row and > reapply > data|validation, does it work? No harm trying "Open and Repair" (in Excel 2003) (idea from a Bob Phillips' post) Save as a spare copy, close the file. Click File > Open, navigate to folder, select the "spare copy" file, then click the arrow dropdown on the right of the "Open" button > choose "Open and Repair" Good luck ! SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > By "Stop Working", I mean that the drop-down arrow has disappeared. The > actualy validation still works though, because Excel doesn't allow me to [quoted text clipped - 3 lines] > seems okay. Allow is set to "list" and both tick boxes on the right are > checked. This worked, thx. Apparently the sheet had "missing validation information". Not sure how that happened though. > No harm trying "Open and Repair" (in Excel 2003) > (idea from a Bob Phillips' post) [quoted text clipped - 4 lines] > on the right of the "Open" button > choose "Open and Repair" > Good luck ! Welcome, glad it helped. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > This worked, thx. Apparently the sheet had "missing validation > information". Not sure how that happened though.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.