data validation

[romskog]

I have a spreadsheet where I have a frozen pane (rows 1:15). This information I want to have on the screen all the time as I scroll down through the rest of the spread. My question is this...why can't I put a validation for a cell in row 8 (or any within this frozen area)? I can put formulas that reference both cells within and outside of the frozen area, and they work fine. You folks have been very helpful in the past...look forward to your answer to this one!

 

[BigC]

Romskog
I'm not sure why Excel won't let you put a validation for a cell in row 8 (or any within this frozen area) but I suspect it thinks that you want those rows frozen as they will be used as titles for the rest of the sheet rather than as a separated work area.
I think your answer may be to use a Split screen (Window / Split)rather than Frozen panes as then both top & bottom "panes" are "active".

HTH
BigC

 

[anno]

hi romskog
this is a known bug in excel 97. see http://support.microsoft.com/default.aspx?scid=kb;en-us;Q236620, where their typically helpful suggestion is to not freeze the panes in the first place. they also helpfully point out that this was fixed on excel 2000, implying that the ultimate solution is...
)
This message was edited by anno on 2002-09-17 23:33

 

[DBA]

G'day,

Not having 97, I am unable to duplicate the problem to test this solution but....

Does it work if you remove the freeze panes, add the validation and then put the freeze panes back on?

Regards,

DBA