Negi1984 Yes, Excel allows to paste the value on the cell ignoring data validation. Moreover, it will be removed if you paste the cell without data validation. Workaround with VBA doesn't work in your case since doesn't work on Excel for web. Another workaround is to use conditi...