Freeze Panes , Data Validation Conflict

[Dav]

Using Excel 97 I have a data validation Drop Down List which works fine
However when freeze panes is selected and the cell with the drop dow
list is in the frozen bit the drop down list ceases to function. An
suggestions to overcome this.

Regards

Da

 

[Paul B]

Dav, if I remember right there was a bug in 97 that validation and freeze
panes did not work together
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Debra Dalgleish]

As Paul said, this is a problem in Excel 97. Instead of Freeze Panes,
you could use Window>Split, and the data validation should work correctly.