Data Validation

[ALMA_J_III]

Hi.

I have data validations in sheet1 as named range lists from sheet2.

When I have deleted sheet2 and copy sheet2 from identical other workbook -
my validations does is not work...

I see Name ranges in copied worksheet, but when I use they in validation - I
have error: "The Source currently evaluates an error. Do you wish
continue?"

Only after deleting of Named ranges in Sheet2 and recreating its, my
validations works.

It is possible after replacing of worksheet with named ranges for
validations (named ranges names are identical) use copied worksheet without
recreating of validation lists?

Thank's,
ALMA_J_III

 

[Debra Dalgleish]

After deleting sheet1, delete the names that were on sheet 1
(Insert>Name>Define). You can use Jan Karel Pieterse's Name Manager
add-in to make this easier:

http://www.oaltd.co.uk/mvp

Then, copy sheet1 from the other workbook, and the data validation
should work correctly.