Validation List Malfunction

[Kncuda]

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).

[Dave Peterson]

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

[Gord Dibben]

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
<[email protected]> 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]

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]

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.