Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
I have a spreadsheet that has several columns that use data validation to
restrict the data input. It was working until a few minutes ago. Now the drop down arrows no longer appear. If I go to Data Validation the menu appears and has the correct list and range. But the arrows still do not appear. I cleared the validation and reentered it and still no arrows. Has anyone ever encounted this? If so, how did it fix it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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 --- "Florida User" wrote: I have a spreadsheet that has several columns that use data validation to restrict the data input. It was working until a few minutes ago. Now the drop down arrows no longer appear. If I go to Data Validation the menu appears and has the correct list and range. But the arrows still do not appear. I cleared the validation and reentered it and still no arrows. Has anyone ever encounted this? If so, how did it fix it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Just thought of something else to add to Max's reply.
ToolsOptionsViewObjects. Checkmark "Show all" if "Hide all" is checked. Gord Dibben MS Excel MVP On Wed, 27 Feb 2008 15:40:02 -0800, Max wrote: 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 ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |