Dropdown menu in Excel AddIn

Hello,

We currently have a dropdown menu in the line items when selecting items from a list - as per image below:

However, when we create the connection with Excel, there is no dropdown nor anyway of knowing the names of the list which have to be manually inputted - please see image below:

Is there any way of giving the end user the options within a given list?

This would be really helpful as the complexity increases with numbered lists, as manually inputted codes are not identified - as far as I am aware.

Cheers!