Cell Validation Not Responding

[Ark68]

I am having a problem.
I have a validated cell that I copy from one protected worksheet to another.
At the source, the cell's list validation works. Click on the cell and the little arrow shows.
However, at the target worksheet, the user can click on the cell (which is unlocked) but their is no little arrow. Checking the cell's properties indicates that there is cell validation in place.

Any idea why I don't have the list validation function?

I can type in the selected cell, and any invalid entry (according to the validation list) will trigger the error message. So the validation list is there, just no option for the drop down.

Jenn

 

[Ark68]

So Colin, I'm scared to be replacing moving around sheets LOL. Excel scares me now LOL.
So, if this resolves the issue, will I not continue to experience this problem in the future? You can see now how I use the cut and paste of the validation, so I assume I will once again exceed the number allowed?

Jenn

 

[Colin Legg]

I don't think you exceeded that limit, Jenn.
[It was a guess - as you can see on the link, that limit does apply to autofilter dropdowns but it may not apply to data validation dropdowns.]

So, if this resolves the issue, will I not continue to experience this problem in the future?

To know that for sure we'd have to know what caused it in the first place... but fingers crossed, no.

 

[Ark68]

I tried your suggestion Colin of moving my haunted worksheet to another blank workbook and bringing it back (an exorcism?) but still did not have any positive results. Still no drop down arrows.

Jenn

 

[Colin Legg]

Strange, it works for me (just did it again to be sure). If it doesn't work for you then I guess you'll have to make a new one like they did on that link I found?

 

[Ark68]

OK ... I rebuilt a new worksheet and everything appears to be working ok.
Now, I can focus on moving ahead vs. spinning my tires and going nowhere but back.

Thanks Colin!!

Jenn

 

[Ark68]

Oh crap.
Lost them again!!
Gone after two hours of successful testing.