2007 Excel Data Validation
 

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:)

2007 Excel Data Validation
 

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.

Gene wrote:
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:)


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

2007 Excel Data Validation
 

THANKS! :-(

"Debra Dalgleish" wrote:

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.

Gene wrote:
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:)


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com