08 June, 2012

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.

7 comments:

  1. Find “EXPTOOWS.XLA” and double click on it.
    What if I don't see this?

    ReplyDelete
    Replies
    1. Can you please elaborate on the SharePoint version and office version you are using?

      Delete
  2. I followed those steps to the letter and I'm still getting the same error.

    ReplyDelete
  3. I'm not sure how I did it,..but my once was XLA is not in XLS form,..how do I change it back,..thanks in advance

    ReplyDelete
  4. thanks for the results 2014, admit card information, notifications, bank
    jobs
    info every day thankyou very much !!

    ReplyDelete
  5. After doing above settings, I see "Cannot connect to server at this time. Your list cannot be published" when I import excel to sharepoint 2013.

    I even gone with IE settings shown in
    http://sharepointknowledgebase.blogspot.in/2011/06/excel-cannot-connect-to-sharepoint-list.html#.VyCMktynqVF.

    But no success.
    Please suggest a solution.

    Thanks,
    Ganesh

    ReplyDelete
  6. I cant find the EXPTOOWS.XLA file. I am using sharepoint 2013. I already unhide all hidden file. please need your help

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.