Validation drop down not working

  • Thread starter Thread starter Lia
  • Start date Start date
L

Lia

I have used the validation- list command to have a drop down list show once
you scroll over the cell. Suddenly however, it stopped working, there is no
arrow. I have tried to clear all validations and start over, but it still
will not work.

Has anyone encountered a problem like this before?

Thanks!
 
Yes.

Have you either manually or through a macro deleted all Shapes on the sheet ??

Doing so will kill the drop-down shape
 
Hi,

Here are some of the reasons you might not see a data validation arrow:

Active Cell Only
Only the active cell on a worksheet will display a data validation dropdown
arrow. To mark cells that contain data validation lists, you can colour the
cells, or add a comment. If you require visible arrows for all cells that
contain lists, you can use combo boxes instead of data validation, and those
arrows will be visible at all times. To create a combo box, choose
View|Toolbars, and select either the Control Toolbox or the Forms toolbar.

Hidden Objects
If objects are hidden on the worksheet, the data validation dropdown arrows
will also be hidden. To make objects visible, choose Tools|Options, and on
the View tab, under Objects, select Show all.

Dropdown Option
In the Data Validation dialog box, you can turn off the option for a
dropdown list. To turn it back on:
- Select the cell that contains a data validation list
- Choose Data|Validation
- On the Settings tab, add a check mark to In-cell dropdown, click OK.

Freeze Panes
In Excel 97, if a Data Validation dropdown list is in a frozen pane of the
window, the dropdown arrow does not appear when the cell is selected. As a
workaround, use Window|Split instead of Window|Freeze Panes. This problem
has been corrected in later versions.
 
I am experiencing the same problem using Excel 2003. The only solution that
worked for me was to unfreeze the panes (thank you very much for that tip).
I wonder if they actually fixed this from the Excel97 version.
 
Back
Top