I created a drop-down list using data validation. For weeks the document
worked fine and I could select options from the drop-down list. However, now
when I click on a cell, the drop-down list doesn't appear. The data
validation setting for the cells is still there and correct.

Why does my drop-down list no longer appear?

thanks
Jen

Has the data in your Source range possibly been deleted? That would
cause a blank list.

jen_writer wrote:
I created a drop-down list using data validation. For weeks the document
worked fine and I could select options from the drop-down list. However, now
when I click on a cell, the drop-down list doesn't appear. The data
validation setting for the cells is still there and correct.

Why does my drop-down list no longer appear?

thanks
Jen

If your validation list was a range of cells or a named range in a worksheet,
it sounds like the data has been deleted from the cells containing your list
choices.
--
Kevin Backmann


"jen_writer" wrote:

I created a drop-down list using data validation. For weeks the document
worked fine and I could select options from the drop-down list. However, now
when I click on a cell, the drop-down list doesn't appear. The data
validation setting for the cells is still there and correct.

Why does my drop-down list no longer appear?

thanks
Jen

Several reasons for this.

See Debra Dalgleish's site for possibles.

http://www.contextures.on.ca/xlDataVal08.html#Freeze


Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 10:49:00 -0700, jen_writer
wrote:

I created a drop-down list using data validation. For weeks the document
worked fine and I could select options from the drop-down list. However, now
when I click on a cell, the drop-down list doesn't appear. The data
validation setting for the cells is still there and correct.

Why does my drop-down list no longer appear?

thanks
Jen

Ignore this.

I read into your post that the Arrow was missing<g


Gord

On Thu, 25 Oct 2007 11:53:18 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Several reasons for this.

See Debra Dalgleish's site for possibles.

http://www.contextures.on.ca/xlDataVal08.html#Freeze


Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 10:49:00 -0700, jen_writer
wrote:

I created a drop-down list using data validation. For weeks the document
worked fine and I could select options from the drop-down list. However, now
when I click on a cell, the drop-down list doesn't appear. The data
validation setting for the cells is still there and correct.

Why does my drop-down list no longer appear?

thanks
Jen

Actually, thanks Gord. After reading the website from your link, I copied my
cells into a new file and the list came back, so I think my file is corrupted.

"Gord Dibben" wrote:

Ignore this.

I read into your post that the Arrow was missing<g


Gord

On Thu, 25 Oct 2007 11:53:18 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Several reasons for this.

See Debra Dalgleish's site for possibles.

http://www.contextures.on.ca/xlDataVal08.html#Freeze


Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 10:49:00 -0700, jen_writer
wrote:

I created a drop-down list using data validation. For weeks the document
worked fine and I could select options from the drop-down list. However, now
when I click on a cell, the drop-down list doesn't appear. The data
validation setting for the cells is still there and correct.

Why does my drop-down list no longer appear?

thanks
Jen

Glad to have helped even though I was off-base.

You can cure just about all maladies with instructions from Debra's site.

Excel maladies, that is<g


Gord


On Thu, 25 Oct 2007 14:09:01 -0700, jen_writer
wrote:

Actually, thanks Gord. After reading the website from your link, I copied my
cells into a new file and the list came back, so I think my file is corrupted.

"Gord Dibben" wrote:

Ignore this.

I read into your post that the Arrow was missing<g


Gord

On Thu, 25 Oct 2007 11:53:18 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Several reasons for this.

See Debra Dalgleish's site for possibles.

http://www.contextures.on.ca/xlDataVal08.html#Freeze


Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 10:49:00 -0700, jen_writer
wrote:

I created a drop-down list using data validation. For weeks the document
worked fine and I could select options from the drop-down list. However, now
when I click on a cell, the drop-down list doesn't appear. The data
validation setting for the cells is still there and correct.

Why does my drop-down list no longer appear?

thanks
Jen