The specified file is not a valid spreadsheet or contains no data to import

Add the sharepoint site to Trusted Sites in Internet Explorer

Found below post as a useful guide

http://yalla.itgroove.net/2011/11/the-specified-file-is-not-a-valid-spreadsheet-or-contains-no-data-to-import/