This file was created by other people in our organisation fairly
recently.
The excel version we have is 2003....so i assume its version 2003....

I did a search on this issue as well and came up with issues relating
to freeze
panes etc ...but this is not even the case with mine... the formatting
of cell and column is good, the sheet is not protected,..so either i
have found a bug in 2003 or alternatively..simply a corrupt
sheet...just don't know how it got corrupted.... note that both
spreadsheets are in the same workbook...one working perfectly as
expected....all releveant tickboxes ticked in data validation...I even
tried the same list entries, spacing etc....anyway worst
case scenario I will simply copy the perfect spreadsheet, and then use
this
as a template for other spreadsheets.


--
abuelj1
------------------------------------------------------------------------
abuelj1's Profile: http://www.excelforum.com/member.php...o&userid=36098
View this thread: http://www.excelforum.com/showthread...hreadid=558767