I've got a workbook with one sheet that is misbehaving. When I try to
set up a validation list, the dropdown arrow does not appear when the
cell is selected, and the cell does not function as a dropdown. This is
true no matter what cell I try on that sheet. All of the other sheets in
the workbook work fine for validation lists. Is there a sheet setting
somewhere that would disable validation lists? (Protection is turned
off on the offending sheet).


--
Kncuda
------------------------------------------------------------------------
Kncuda's Profile: http://www.excelforum.com/member.php...o&userid=28967
View this thread: http://www.excelforum.com/showthread...hreadid=487005

There was a bug in xl97 that would stop the Data|Validation from working if the
cell was in the top portion of the window after a Window|freeze panes?

Any chance you're using xl97 and have freeze panes turned on?

Kncuda wrote:

I've got a workbook with one sheet that is misbehaving. When I try to
set up a validation list, the dropdown arrow does not appear when the
cell is selected, and the cell does not function as a dropdown. This is
true no matter what cell I try on that sheet. All of the other sheets in
the workbook work fine for validation lists. Is there a sheet setting
somewhere that would disable validation lists? (Protection is turned
off on the offending sheet).

--
Kncuda
------------------------------------------------------------------------
Kncuda's Profile: http://www.excelforum.com/member.php...o&userid=28967
View this thread: http://www.excelforum.com/showthread...hreadid=487005

--

Dave Peterson

You sure you have "in cell dropdown" checked?

Otherwise perhaps Dave's answer will cover the problem.


Gord Dibben Excel MVP

On Mon, 21 Nov 2005 15:37:44 -0600, Kncuda
wrote:


I've got a workbook with one sheet that is misbehaving. When I try to
set up a validation list, the dropdown arrow does not appear when the
cell is selected, and the cell does not function as a dropdown. This is
true no matter what cell I try on that sheet. All of the other sheets in
the workbook work fine for validation lists. Is there a sheet setting
somewhere that would disable validation lists? (Protection is turned
off on the offending sheet).

I'm in xl2000, and freeze panes was on when I first tried to set up the
validation list. I tried turning it off and the problem still exists.
'In Cell Dropdown' was checked. The bug may still exist in xl2000. Do
you know of a way to fix it without rebuilding the sheet? (It's got
hundreds of links to other sheets, and would be a real pain to
rebuild).


--
Kncuda
------------------------------------------------------------------------
Kncuda's Profile: http://www.excelforum.com/member.php...o&userid=28967
View this thread: http://www.excelforum.com/showthread...hreadid=487005

I just tried another test. Other sheets in the offending workbook with
freeze panes enabled show no problems establishing validation lists in
the upper portion. It's only a problem on one sheet, and the problem
occurs throughout the sheet, not just the upper portion.


--
Kncuda
------------------------------------------------------------------------
Kncuda's Profile: http://www.excelforum.com/member.php...o&userid=28967
View this thread: http://www.excelforum.com/showthread...hreadid=487005