2007 Excel Data Validation

G

Gene

I created a LIST Data Validation (I typed the entries into the window) for an
entire column. When I paste into the column or download data into the column,
the Data Validation "goes away" (is removed by the resulting paste or
download.

Anyway to "keep" the Data Validation?

MUCH THANKS!
Happy Holidays!
Gene:)
 
D

Debra Dalgleish

No, the data validation is designed to check entries as you type them
into a cell. Unfortunately, you can paste or download invalid data into
the cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Conditional Data Validation 2
Conditional Data Validation Options 2
Using Data Validation with a vlookup formula 3
2007 data validation not working 1
data - validation - list question 2
Data validation accepts illegal entries when one spreads values 5
Validation protection 2

Top