Hi all

I have a workbook that has validations applied to it and it works great!!!

I want to "change" the defined name in the source section to be a different
defined name/range, but I get this message when I enter :

"You may not use references to other worksheets or workbooks for Data
Validation Criteria"

I don't understand why it worked previously and why it doesn't work now.

I created this template back in December - would an upgrade affect it???

Other information:

To create the lists I used "defined names" as the lists are within another
workbook - this is the only way to do this...

To enter the defined name into the validation screen I used "name / paste"...

Under TOOLS / OPTIONS / CALCULATION the option to Accept labels in formulas
has been selected.

The excel template is saved on a Network along with the datafile where the
list lives.

If anyone can shed some light on why I can't do what I was able to do
previously please let me know asap.

--
Thank for your help
BeSmart