Hi,

I’ve noticed Data Validation is not listing suggested completions, in a dropdown list shortened from the original list to include only valid completions, for column A:A only.  (It used to).

Inserting a blank column A:A resolves the issue

Unchecking {View, Headings} resolves the issue

Only some users are affected

The user affected has the app based version of Excel through Office365, but others also have exactly that setup, and don’t have difficulties.

The list Data Validation references a named table on another sheet, that way users can extend the valid inputs easily, should they need to.

Why is only the first column affected? And why does inserting a blank column resolve it?

I should add, the cut down allowable completions list is visible for about 1/100th of a second, but only once. Then won’t appear again until you click away and click back.

Also, the dropdown arrow still provides access to the scrollable list in full.

Columns other than A:A on the same sheet have the same {named table, list Data Validation} arrangement and work perfectly.

Search engines suggest I’m not alone. (But then I got accused of hijacking someone else’s thread, so I hightailed it here instead!)

Thanks,

Michael.

​Hi, I’ve noticed Data Validation is not listing suggested completions, in a dropdown list shortened from the original list to include only valid completions, for column A:A only.  (It used to). Inserting a blank column A:A resolves the issueUnchecking {View, Headings} resolves the issueOnly some users are affected The user affected has the app based version of Excel through Office365, but others also have exactly that setup, and don’t have difficulties. The list Data Validation references a named table on another sheet, that way users can extend the valid inputs easily, should they need to. Why is only the first column affected? And why does inserting a blank column resolve it? I should add, the cut down allowable completions list is visible for about 1/100th of a second, but only once. Then won’t appear again until you click away and click back. Also, the dropdown arrow still provides access to the scrollable list in full. Columns other than A:A on the same sheet have the same {named table, list Data Validation} arrangement and work perfectly. Search engines suggest I’m not alone. (But then I got accused of hijacking someone else’s thread, so I hightailed it here instead!) Thanks, Michael.  Read More

​