Same issue as this Cannot import spreadsheet into SharePoint. This feature requires a browser that supports ActiveX controls but answers don't work.
When I click "import" I get:
"Cannot import spreadsheet into SharePoint. This feature requires a browser that supports ActiveX controls"
ActiveX is obviously enabled in IE11.SP sites are all in trusted lists.
This worked fine in retail Office 2010 but recent update to 2016 via Office 365 has broken it. Nothing else has changed in our environment so this is a Msft bug which they don't seem to know how to resolve.
IE11 32bit on Windows 7 Enterprise Office 2016 is 32bit.
Using a machine with Office 2013 and IE10, the import dialog opens but once the cell range is selected, I get: "An unexpected error has occurred."