Data Validation - Dropdown List Not Appearing

[Guest]

Hello, I am using MircoSoft Excel 2002.

I created a file, and a worksheet within contained cells which had a
dropdown list affixed via Data>Validation>Allow: List (and then a named range
within the Source field). The "In-Cell DropDown" list box was checked.

The users then informed me that the drop-down list of the cells no longer
appered, so I checked the validation settings, and the original settings are
still there, yet the dropdowns do not appear upon activating the given cells.
Instead of trying to determine how this occurred, via Edit>Clear>All, I
cleared the validation settings for the cells and applied the settings again,
but still the dropdown list does not appear in the given cells. (fyi, the
file is not Shared)

I have used this type of validation in the past without any issues, but now
the list does not appear. Can anyone advise as to how to resolve this
situation.

Any and All Help Is Appreciated - Thanks In Advance

 

[Bob Phillips]

A couple of previous suggestions from Debra Dalgleish and Gord Dibben

Are objects visible?

To make them visible, choose Tools>Options
On the View tab, for Objects, select Show All, or Show Placeholders


Excel 97 also had a problem showing DV drop-down arrows when Window>Freeze
Panes was enabled. Anything above the "freeze line" would be hidden.

--

HTH


RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob, Thank You for the response.

Via Tools>Options>View The "Show All" radio button is selected. I also
changed it to "Show Placeholders" but it did not resolve the issue.

There are panes frozen, but I did try via Windows>Unfreeze Panes, but the
issue remains.

Any other suggestions?