Drop-down arrow (Data-Validation-List) disappears (Excel 2003)

[Guest]

Hi,

I'm very much used to working with the different possibilities of the
Data-Validation feature and am pretty satisfied with it. Nevertheless for no
apparent reason sometimes the arrow indicating that there is a dropdown-list
available disappears. Strange enough the parameters are yet correct (eg. the
zone determining the cells to appear in the list is still correct).

Has anyone an explanation/solution for this problem?

 

[Ron Rosenfeld]

Hi,

I'm very much used to working with the different possibilities of the
Data-Validation feature and am pretty satisfied with it. Nevertheless for no
apparent reason sometimes the arrow indicating that there is a dropdown-list
available disappears. Strange enough the parameters are yet correct (eg. the
zone determining the cells to appear in the list is still correct).

Has anyone an explanation/solution for this problem?

I don't suppose the In-cell dropdown option has become de-selected?


--ron

 

[Bob Phillips]

Have you run any code to delete shapes, buttons or such like?

 

[Guest]

Hi Ron,

No, the "in-cell dropdown" remains selected.

"Ron Rosenfeld" a écrit :

 

[Guest]

Neither nor. No specific or complexe intervention was executed on the file.

"Bob Phillips" a écrit :

 

[Arvi Laanemets]

Hi

Haven't you used Freeze Panes with column with data validation as rightmost
fixed one?

 

[Guest]

Hi Arvi,

No, nor Freeze Panes nor Split Windows. Is there any way I could send you
guys the file in question? (am for the first time on this discussion forum)


"Arvi Laanemets" a écrit :

 

[Bob Phillips]

I am happy to take a look. Note the spam filter in my addy which needs to be
removed - the nothere

 

[Guest]

I posted it to you a moment ago - hope it went through well.

Thanks in advance for having a look at it.

"Bob Phillips" a écrit :

 

[Ron de Bruin]

Have you look in Tools>Options View
See the Objects line