| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.programming
|
|||
|
|||
|
Data Validation doesnt work with Copy/Paste
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PASTE DOESNT WORK | Excel Worksheet Functions | |||
| Data Validation doesnt work with 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) | |||
| Data validation does not seem to work with copy/paste | Excel Discussion (Misc queries) | |||
Linear Mode
