You are not trying to use a localised name by any chance, one whereby you
specify =Sheet3!rng in the DV? It doesn't seem to like this.
--
HTH
Bob Phillips
"BeSmart" wrote in message
...
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
|