Method 'Post' of object 'IOWSPostData' failed SharePoint 2010

Guys, before I start writing on this error message, let me clarify that I have tested this issue in two environments:

·         SharePoint 2010 and Office 2007

·         SharePoint 2010 and Office 2010

Directly Jumping on to the troubleshooting steps, let me brief some details as how I reproduced that error message:

·         Open your SharePoint site

·         View all site content / http://SharePoint2010/sites/SPAdmin/_layouts/create.aspx  

·         Custom list section

·         Import a spreadsheet (refer the following screenshot)

·         Provide appropriate details for the Name field

·         Select an excel spreadsheet that you wants to import by means of Browse option

·         Range of cells

·         As soon as you selects the range of cells and click Ok then you will get the below mentioned error message:

Method 'Post' of object 'IOWSPostData' failed

First condition: SharePoint 2010 and Office 2007

If you are using the above combination then it’s never going to work.

Second condition: SharePoint 2010 and Office 2010

Its working perfectly without any problems, if you are facing the mentioned error message for this combination then here is the resolution for this:

·         Go to “C:\Program Files\Microsoft Office\Office14\1033”.

·         Find “EXPTOOWS.XLA” and double click on it.

·         Press “Alt+F11” to display VB code editor.

·         Select code window and find “lVer = Application.SharePointVersion(URL)”

·         Add following line “lVer = 2”.

·         Save and close the window.

·         Restart and see if it worked.

·         If not, change “lVer = 3”.

·         Restart and see if it worked.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.