MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Dropdown list not working within freeze panes


Posted by Chris D on February 13, 2002 6:35 AM

Hi all,

a minor irritation : I have a drop down list via data validation that drops down from row 6 to row 12

when I freeze panes beneath it, or even below row 12 (say row 20) the drop down doesn't function..... the little button doesn't want to show and the list doesn't appear..

is this something I'm just going to have to live with ?

cheers
Chris


Posted by Mudface on February 13, 2002 6:46 AM

I had the same problem a while back and could only solve it by moving the freeze position. I think it's a documented 'bug' in Excel, but if anyone does know if there's a solution I'd love to know it, too.

Posted by Chris D on February 13, 2002 6:52 AM

Okie doke...:-( cheers Mudface :-)

Posted by Mudface on February 13, 2002 6:53 AM

Here's a reference from Micrsoft

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q236620