Hi to all,
I have a excel sheet that contain data validation for checking character lenth. If i copy / paste a value in that cell the validation doesn't check, until i press f2 for rechecking. The file contain around 1000 cell in each colomn with several rows with different validation viz date check, number check, and every time i have to press f2 in each cell. Any other option, plz help