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, more likely, your user does not have the rights to query this hidden SharePoint service.  There are many other reasons why this might fail but the long and short of it is that you need to change excel’s call to check SharePoint’s version.

Solution

• Open C:\Program Files\Microsoft Office\Office12\1033\exptoows.xla
• Press Alt-F11 to open VBA
• 

• Modify the initialize function as follows
• 

• You may see this message next time you launch the import from SharePoint

Popularity: 9% [?]