View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Why isn't the drop down showing using data validation?

That would be Excel 97


Regards,

Peo Sjoblom

ebruder wrote:
On certain versions of Excel if you have "Freeze Pane" active the drop downs
will not show. This is a "known issue" according to MS. If the panes are
frozen, unfreeze the pane and the drop downs will show.

"IDill95" wrote:

I have created several cells with data validation but one of the worksheets
in my workbook doesn't show the drop down list. I can't figure out why. Any
ideas?