Validation above the Freeze Line
 

Hi All......

I have a cell to which I have appied Data Validation with a drop down box.
The cell is located above the Window Freeze Line on my sheet. Although the
"data Validation" part seems to work ok, the drop down arrow and window do
not appear, unless I delete the Freeze Line. This is my first observance of
this situation. Is it ordinary?.....Might I have some setting wrong?.....is
there a workaround?

Vaya con Dios,
Chuck, CABGx3

This is a known bug in Excel 97

--
Regards,

Peo Sjoblom


"CLR" wrote in message
...
Hi All......

I have a cell to which I have appied Data Validation with a drop down box.
The cell is located above the Window Freeze Line on my sheet. Although
the
"data Validation" part seems to work ok, the drop down arrow and window do
not appear, unless I delete the Freeze Line. This is my first observance
of
this situation. Is it ordinary?.....Might I have some setting
wrong?.....is
there a workaround?

Vaya con Dios,
Chuck, CABGx3

Thanks Peo.......

Indeed, that's what this machine has on it.......maybe a good enough reason
for an upgrade<g

Vaya con Dios,
Chuck, CABGx3



"Peo Sjoblom" wrote:

This is a known bug in Excel 97

--
Regards,

Peo Sjoblom


"CLR" wrote in message
...
Hi All......

I have a cell to which I have appied Data Validation with a drop down box.
The cell is located above the Window Freeze Line on my sheet. Although
the
"data Validation" part seems to work ok, the drop down arrow and window do
not appear, unless I delete the Freeze Line. This is my first observance
of
this situation. Is it ordinary?.....Might I have some setting
wrong?.....is
there a workaround?

Vaya con Dios,
Chuck, CABGx3

Hi Chuck,

Instead of a Freeze line, you could split the window, and the dropdown
should work.

Debra

CLR wrote:
Thanks Peo.......

Indeed, that's what this machine has on it.......maybe a good enough reason
for an upgrade<g

Vaya con Dios,
Chuck, CABGx3



"Peo Sjoblom" wrote:


This is a known bug in Excel 97

--
Regards,

Peo Sjoblom


"CLR" wrote in message
...

Hi All......

I have a cell to which I have appied Data Validation with a drop down box.
The cell is located above the Window Freeze Line on my sheet. Although
the
"data Validation" part seems to work ok, the drop down arrow and window do
not appear, unless I delete the Freeze Line. This is my first observance
of
this situation. Is it ordinary?.....Might I have some setting
wrong?.....is
there a workaround?

Vaya con Dios,
Chuck, CABGx3







--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra,
I never thought of that......I'll give it a try.

Vaya con Dios,
Chuck, CABGx3



"Debra Dalgleish" wrote:

Hi Chuck,

Instead of a Freeze line, you could split the window, and the dropdown
should work.

Debra

CLR wrote:
Thanks Peo.......

Indeed, that's what this machine has on it.......maybe a good enough reason
for an upgrade<g

Vaya con Dios,
Chuck, CABGx3



"Peo Sjoblom" wrote:


This is a known bug in Excel 97

--
Regards,

Peo Sjoblom


"CLR" wrote in message
...

Hi All......

I have a cell to which I have appied Data Validation with a drop down box.
The cell is located above the Window Freeze Line on my sheet. Although
the
"data Validation" part seems to work ok, the drop down arrow and window do
not appear, unless I delete the Freeze Line. This is my first observance
of
this situation. Is it ordinary?.....Might I have some setting
wrong?.....is
there a workaround?

Vaya con Dios,
Chuck, CABGx3







--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html