Data validation list dropdown arrow cannot be selected

Question

Data validation list shows the dropdown arrow, but the arrow cannot be selected to view the dropdown list.

When the cell is right-clicked and 'Pick from drop-down list' selected, some options are shown, but not all.

This is happening with lists that are hard-coded in the data validation Source field, as well as with lists pointing to a named range.

Every now and then it will randomly work, but only one time before it stops working again, and I can't pinpoint why it worked those times.

The files are saved in a Microsoft Team, opened in the desktop application.

My Excel desktop application information: Microsoft® Excel® for Microsoft 365 MSO (16.0.14026.20326) 64-bit

Ruled out all the potential causes suggested in all available help documentation:

• Objects are not hidden.
• No macros/VBA in file.
• File not corrupted (occurring on multiple files, repair did no resolve the issue).
• Data validation option 'in-cell dropdown' is checked.
• Tables are not connected to a SharePoint list.
• Freeze panes is not on.
• Worksheet is not protected.

This is seriously impacting my ability to use Excel.

Answer 1

Thank you for posting the solution that you found. I doubt that anyone else would have found that.

You can report the problem yourself via Feedback.

Open Excel

Select File - > Feedback

Click "Send a frown" and follow the prompts

Answer 2

Hi Sara,

Thanks for sharing the solution with the community, I am sure it will help someone who has the same issue.

Regarding reporting the issue, the quickest route to our developers’ ears is right from within Office app. In Excel, click File > Feedback and send the feedback directly to the Product group. This will have more impact on the Product Group as the feedback is coming directly from the customer.

Kind Regards,

Neha