Freeze Panes , Data Validation Conflict

  • Thread starter Thread starter Dav
  • Start date Start date
D

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
 
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
 
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.
 
Back
Top