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 |
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 |
All times are GMT +1. The time now is 06:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com