Drop-down arrow and list missing

Question

Hi,

In a workbook I made some dropdown lists for selectio of data. I copied these between sheets. In one sheet in the workbook the dropdown function does not seem to work. The arrow is missing and the dropdown list is missing, but if I delete text in the celll with the list and start typing text from an item on the list, hten the list appears - still without the dropdown arrow. I checked that everything is set correctly in the data validation settings, noe panes are frozen.

How can I share the workbook with the problem?

with hopes for help,

Pia

Answer 1

Data validation>Check both options. Then it works.

Answer 2

and mabe I should post the link too: Modeltemplate microsoft.xlsx

Answer 3

HI,

Here a link to a workbook showing the problem. oddly, som dropdowns have come to function after saving in af new name - others don't. Look e.g. in the sheet "Lav afstand_samarb" H14 and J14. After saving H14 works, but J14 does not.

Answer 4

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Or

You may upload file in private message.

Private Messages - Microsoft Community