Rather than using Data Import from the External data menu, you could
try using New Database Query from the same menu and choose Excel
Files* as the data source.This method uses ODBC/SQL to extract data.

Is there a reason you need to open the source file while the query is
connected? This can lead to other issues like memory leaks.

Cliff Edwards