If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data validation does not seem to work with copy/paste
I have set up some data validation for each cell within a range. When I manually enter invalid data in one of those cells, the data validation works and an error message pops up. When I copy from one cell with data to another cell, where the data validation results in false, it allows me to paste the value with no error message. Is there any way to fix this? -- LAF ------------------------------------------------------------------------ LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656 View this thread: http://www.excelforum.com/showthread...hreadid=468024 |
#2
|
|||
|
|||
Type "Data Validation" into Excel Help...and click on "troubleshooting data validation"... you'll see: Code: -------------------- Copying, filling, and calculating by formula override my data validation. Data validation is designed to display messages and prevent invalid entries only when users type data directly in a cell. When data is copied, filled, or calculated by a formula, the messages don't appear. -------------------- The help file goes on to list several ways to disable copy/paste to prevent this issue. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=468024 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Validation does not work when selecting another cell. | Simon Jefford | General Discussion | 5 | June 29th, 2005 11:10 PM |
Data Validation doesn't work on 1 sheet only | lunker55 | General Discussion | 4 | February 25th, 2005 05:25 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Data validation failures | RogerNZ | General Discussion | 1 | July 21st, 2004 11:46 PM |
Using Named Ranges with Data validation | Kevin | General Discussion | 3 | June 20th, 2004 10:34 PM |