Freeze Panes , Data Validation Conflict
 

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 down
list is in the frozen bit the drop down list ceases to function. Any
suggestions to overcome this.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=523599

Freeze Panes , Data Validation Conflict
 

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

"Dav" wrote in message
...

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 down
list is in the frozen bit the drop down list ceases to function. Any
suggestions to overcome this.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=523599

Freeze Panes , Data Validation Conflict
 

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

Dav wrote:
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 down
list is in the frozen bit the drop down list ceases to function. Any
suggestions to overcome this.

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