We will discuss in this post on how to solve the issue "Method 'Post' of object IOWSPostData failed' which comes when you try to import an excel spreadsheet to SharePoint 2010 list.
Also you can check my previous posts on:
Follow below steps to resolve the issue.
- First go to c:\Program Files\Microsoft Office\Office14\103\ location.
- Then find EXPTOOWS.XLA and double click on it.
- Then open VB code editor by clicking on Alt+F11.
- Then find "IVer = Application.SharePointVersion(URL)"
- Add the line "IVer =2"
- Then Save and Close the window.
- Then Restart and check, now the error should not come.