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.
You are attempting to import a spreadsheet into a SharePoint list probably with Office 2007 (12).
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.
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
Rating: 9.0/10 (4 votes cast)
Rating: 0 (from 0 votes)
Method ‘post’ of object ‘IOWSPostData’ failed when attempting to import an Excel spreadsheet, 9.0 out of 10 based on 4 ratings
Ulysses Ludwig is a SharePoint architect with over 16 years in the IT and computer industry. Ulysses' primary focus is SharePoint but he dabbles in the latest web technologies and likes to develop software in his spare time.
Comment for Method ‘post’ of object ‘IOWSPostData’ failed when attempting to import an Excel spreadsheet