This article is based upon a fix I found on Msft’s website that didn’t have an screenshots, as they say, a picture tells a thousand words so hopefully this article helps you out.
Problem
You are attempting to import a spreadsheet into a SharePoint list probably with Office 2007 (12).
Explanation
Excel queries SharePoint to determine the version. What's most likely happening is that Sharepoint queries the root site such as http://sharepoint , which might not contain a SharePoint site or, mo...