No Drop Down Tab showing

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?
 
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
 
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
 
The dropdown won't show if objects are hidden.

To show them, choose Tools>Options
 
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.
 
It doesn't work though I've done as suggested.

Debra Dalgleish said:
The dropdown won't show if objects are hidden.

To show them, choose Tools>Options
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down fill box does not appear when cell clicked. 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Created invoices in Excel - not working in Drive 1
customize drop-down box 1
validation 3
Creating dynamic ranges which are named. 1
Excel 2003-Data Validation drop down list not working? 2
Vlookups not working 2

Back
Top