Drop Down List

[bohon79]

Hello,

Wanted to know if anyone is having issues with drop down list and is there a way to fix it.

I have a drop down list that works but when I save it and closed the sheet and then reopen later on the data in the list changes. I have it look at a column but the data changes to looking at a row.

any help

Erick

 

[Chrisdontm]

Are you using a formula to declare the range of the drop down list?, if so could you post the formula...

 

[bohon79]

no, using the data validation option

 

[Chrisdontm]

I don’t see why it would do that.
I would remove the data validation, save the changes, then set it up again.