Data Validation doesnt work with Copy/Paste

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

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

Hi xmux

Pasting into a cell with data validation will remove the data validation, as
you describe. The way round this is to to do Paste Special - Values. This
will allow unvalidated data to be input but will also retain the data
validation criteria.

"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