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

C

CaraVanTea

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?
 
R

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?
Click to expand...

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


--ron
 
C

CaraVanTea

Hi Ron,

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

"Ron Rosenfeld" a écrit :
 
C

CaraVanTea

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

"Bob Phillips" a écrit :
 
A

Arvi Laanemets

Hi

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

CaraVanTea

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 :
 
B

Bob Phillips

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

CaraVanTea

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 :
 
C

CaraVanTea

Hi Ron,

The "Tools>Options>View" is on "Show all". Guess that's correct.

"Ron de Bruin" a écrit :
 
R

Ron de Bruin

Hi Bob
never got it.
Click to expand...
Ahaaa


Hi CaraVanTea

You can send it to me also if you want.
I use a real mail address in this newsgroup.

I will send it to Bob when I don't see the problem
 
C

CaraVanTea

Addendum

Ron,

There's actually another quite strange behaviour: If you doubleclick on the
Column-Width (column A) an error report will be generated. If you open the
restored file afterwards, the dropdown reappears.

Nevertheless it doesn't give me the answer why it disappears in the first
place....

Good luck

"Ron de Bruin" a écrit :
 
Top