Thread: Data Validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.