Because on your system only Microsoft excel(.xls) driver will be installed. so it will work with only .xls files.
first you have to install driver to support .xlsx. then you will be able to connect.
One more thing might be possible. the permission on a system. if you will use DSN in your connection string then if at the time if connection string generation user permission rule will follow so it might not work on other system due to permission issues.