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.

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.

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 !