Technical Tips and Solutions
04/04/2003 - Validation disappears from spreadsheet in Excel 97
If you freeze panes in Excel 2000 after having put validation in cells you will find that if opened in Excel 97 the validation function is no longer available. The solution is to unfreeze the panes, and the validation will reappear!