Data Validation List - Drop down appears empty if source contains only one item

[jmancha]

I am not certain if this is an excel issue or Citrix issue but it is worth a try. . .

I am using Excel 2016 in a Citrix environment. When using the Data Validation list option I am unable to use the drop down if my source contains only one item. For example, I have a field where the only available selection is YES. I do this because other fields validate from this field and the field must contain only YES.

I can see the arrow but when I click on it nothing happens. I have the list set to Stop on invalid data and it will still only allow the entry of YES, however you would have to know what entry is available or view the Data Validation properties to determine the acceptable entry for this field.

This issue is the same even if the source is a named range so long as that range has only on item. For sources > 1 the list works as expected.

 

[Fluff]

I don't have any problems with a range of 1 cell, so it may be Citrix.
As you only have 1 value try removing the range from the source box & replace it with YES (no quotes), does that help?
A workround is to add an "Input message" telling the user what to enter.

 

[jmancha]

Thank you for your response!

Sadly, this did not work and I appreciate your work around as this may be what I need to do. My concern is I have been building forms in Excel for 15+ years that are used by a large group of people. Who knows how many documents this will have to be corrected on!!! I am working n the Citrix side but so far I have not fund any solution there.

 

[Fluff]

Is it all files that have this problem, or just this one?

 

[jmancha]

Any Excel document. Macro Enabled or Not.

 

[Fluff]

That would tend to rule out a corruption issue, so it sounds like Citrix maybe the problem.

 

[jmancha]

OK! Wish me luck!

Have a great day and thanks again. .

 

[Fluff]

You're welcome & thanks for the feedback

Good luck