Hi,

What does "tip" mean? Maybe you should increase the gratuity.

Actually, tell us what the data validation is. If it is a formula make sure
the references are absolute.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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