Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation doesnt work with Copy/Paste
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation doesnt work with Copy/Paste
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - copy paste ! | Excel Worksheet Functions | |||
Links doesnt work in the copy version of the original sheet | Excel Discussion (Misc queries) | |||
Formula doesnt work when copy in different cell | Excel Discussion (Misc queries) | |||
Copy/Paste over rides data validation | Setting up and Configuration of Excel | |||
Data validation does not seem to work with copy/paste | Excel Discussion (Misc queries) |