It does allow for typing and the connection fails.

How I get to the drop down box in Excel 2016: Data tab, From other sources, From Microsoft Query, "<New Data Source>"...