Data Validation in Excel 2002

[grio_lfc]

I have a workbook with a sheet in called 'Validation'. This sheet is
hidden and contains a number of lists that I use for data validation.

Using previous versions on Excel, I have always defined names for these
lists then on other sheets within the workbook I use the data
validation command using the List option in the Allow field then enter
the name of the list in the Source field, using the option for an
In-cell Dropdown. Upon entering that cell a drop down list was
available populated with the list from my Validation sheet.

Now in Excel 2003, when I attempt the same and look at the dropdown
list it just has the name of the list. If I put the valildation list on
the same sheet as the cell then it works. Just fails when the
validation list is on a separate sheet within the book.

Has anyone else come across this and more importantly does anyone have
a resolution for it?!

Cheers

 

[DNF Karran]

=INDIRECT("[range name]")

Should work

In excel 2000 I get the "problem" where the ranges name cannot b
directly input if I put:

ABC

but if I put

=ABC

it works as does

=INDIRECT("ABC")

Hope this helps

Dunca

 

[Frank Kabel]

Hi
the entry
=your_defined_name

should work. Don't forget to enter the equation sign at the beginning

 

[grio_lfc]

Thanks Duncan, but I'm not sure that's the answer for me.

The worksheet where I'm trying to get the data validation to work is
input sheet where I need the user to select from a drop down lis
within the cell.

After looking at INDIRECT, I don't think that's the answer

 

[grio_lfc]

Sorted!

Thanks, I'm sure I never used to have to key the "=" sign in o
previous versions though.

Never mind, least it's working now

 

[grio_lfc]

Sorted!

Thanks, I'm sure I never used to have to key the "=" sign in o
previous versions though.

Never mind, least it's working now