Hi everyone!

I have a problem with my datavalidation on excel, i did the columns
where i need data validation and it works perfectly when i tip the
things.. but if i dont tip and just copy paste from somewhere the
datavalidation doesnt check anymore! how can i check it again?

Thanks

THe data validation probably stops working because you are overwriting the
cells when you paste. Try paste special values and see if it does what you
wnat.

"xmux" wrote:

> Hi everyone!
>
> I have a problem with my datavalidation on excel, i did the columns
> where i need data validation and it works perfectly when i tip the
> things.. but if i dont tip and just copy paste from somewhere the
> datavalidation doesnt check anymore! how can i check it again?
>
> Thanks
>