No Drop Down Tab showing

J

John

Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?
 
F

Frank Kabel

Hi
I heard from some 'corrupted' files esp. with Excel 97 (even had this some
time on my own). Easiest solution: Re-build the sheet
 
J

John

Saw posting on the Group on XL97 with Freeze frames etc, I'm on XL2002, I
just recreated the whole sheet and it worked fine

Thanks
 
D

Debra Dalgleish

The dropdown won't show if objects are hidden.

To show them, choose Tools>Options
 
L

LA

i have had the same problem as you regarding the dropdown tab showing. I'm on
XL2003. The only thing I can do is to copy entire data in the worksheet
having the problen to another worksheet, re-establish the links to my model
and then it works normally.
 
Top