My organization has Excel 97 (Yeah, I know, the stone age!) I've encountered a documented bug in Excel 97 whereby if you freeze panes on a section of the worksheet that has data validation drop-down boxes, they stop working. Is there any programmatic workaround to get around this problem, like coding something in the worksheet event code? Thanks in advance.