Drop Down Lists won't work

[Guest]

Hi,

I have a problem with Drop down lists in Excel.

I'm using Office 97, and have created a drop down list using the 'Data', 'validation', and then 'list' commands. This was working, but for some reason the list command has now stopped working. It doesn't matter what i type in for a list - a range, or discrete values - that list does not appear. Other functions of the 'validation' do work, such as time, date, whole numbers.

Is there another tick box somewhere that needs to be set in order for the lists to work (apart from the one on the validate page saying 'in-cell dropdown' which is ticked)?

This is really frustrating me.

On a related point - if you try to specify a range for the list you can only do that on the same worksheet. Does anyone know of a way to reference a range on another worksheet?

Thanks,

Andy

 

[Paul]

Hi,

I have a problem with Drop down lists in Excel.

I'm using Office 97, and have created a drop down list using the 'Data',

'validation', and then 'list' commands. This was working, but for some
reason the list command has now stopped working. It doesn't matter what i
type in for a list - a range, or discrete values - that list does not
appear. Other functions of the 'validation' do work, such as time, date,
whole numbers.

Is there another tick box somewhere that needs to be set in order for the

lists to work (apart from the one on the validate page saying 'in-cell
dropdown' which is ticked)?

This is really frustrating me.

On a related point - if you try to specify a range for the list you can

only do that on the same worksheet. Does anyone know of a way to reference
a range on another worksheet?

Thanks,

Andy

When you type in the source for your list, you need an equals sign:
=$A$1:SA$10
Did you forget this?

If your range is on another sheet, give that range a name (e.g. "list1") and
use the name in the source box:
=list1

 

[Don Guillett]

In the "other sheet", type in your list and name it or make it a defined
name such as mylist
Select the range for validation>In data validation>select list>type in
=mylist
All else fails, go here
http://www.contextures.com/tiptech.html

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi,

I have a problem with Drop down lists in Excel.

I'm using Office 97, and have created a drop down list using the 'Data',

'validation', and then 'list' commands. This was working, but for some
reason the list command has now stopped working. It doesn't matter what i
type in for a list - a range, or discrete values - that list does not
appear. Other functions of the 'validation' do work, such as time, date,
whole numbers.

Is there another tick box somewhere that needs to be set in order for the

lists to work (apart from the one on the validate page saying 'in-cell
dropdown' which is ticked)?

This is really frustrating me.

On a related point - if you try to specify a range for the list you can

only do that on the same worksheet. Does anyone know of a way to reference
a range on another worksheet?

 

[Debra Dalgleish]

In Excel 97, if the cell with data validation is in a frozen pane of the
window, the dropdown won't work. If that's the cause, perhaps you could
split the window, instead of freezing the panes.

I'm using Office 97, and have created a drop down list using the

'Data', 'validation', and then 'list' commands. This was working, but
for some reason the list command has now stopped working. It doesn't
matter what i type in for a list - a range, or discrete values - that
list does not appear. Other functions of the 'validation' do work, such
as time, date, whole numbers.

Is there another tick box somewhere that needs to be set in order for

the lists to work (apart from the one on the validate page saying
'in-cell dropdown' which is ticked)?

This is really frustrating me.

On a related point - if you try to specify a range for the list you

can only do that on the same worksheet. Does anyone know of a way to
reference a range on another worksheet?

 

[Guest]

Thanks

The problem was indeed with the frozen panes

The tip on how to access lists on other sheets was extremely useful as well

All the best

Andy