There was a problem with xl97 and cells with data|validation that were above the
freeze panes row.

But I think the arrow still showed up--it just didn't work. (any chance that
you have that configuration).

And as a workaround, can you remove the data|validation and add it back? Maybe
it'll work there.

(or maybe just toggling that in-cell dropdown checkbox. Turn it off, close up
the dialog and turn it back on--maybe????)

lunker55 wrote:

Does anyone else have any ideas??
Joe

"lunker55" wrote in message
...
Hide all is unchecked.
Show all is checked.
I think all my options are right because I opened a new file and I can get
it to work fine.

Joe

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You sure you looked at everything in ToolsOptions?

How about ToolsOptionsViewObjects "hide all"?

Checked or unchecked?


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 11:10:24 -0500, "lunker55"
wrote:

I have a column with a data validation list.
My drop down arrow doesn't show up anymore when I select the cell.
It has been working for a year with no problem.
Where did it go?
I looked in Tools-Options to see if anything was unchecked, but all looks
good.
Any ideas?
Joe
Excel 2003





--

Dave Peterson