Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze pane line | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Data Validation Window? | Excel Discussion (Misc queries) |