Data Validation doesnt work with Copy/Paste

  • Thread starter Thread starter xmux
  • Start date Start date
X

xmux

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation items limit 2
Using Validation List from Another Workbook with Dependent Data 6
Validate if cell use data validation 2
How to use both Vlookup & data validation 1
Protecting data validation Drop DownColumn 3
Referencing data validation list in IF Statement 2
Using Table Column for Data Validation List 2
Problem with setting value in validated range 3

Back
Top