Blog Archives

Problem when importing Excel spreadsheet to Sharepoint List

I came to the following error message when trying to import a shreadsheet into Sharepoint List:

Method ‘Post’ of object ‘IOWSPostData’ failed

I found a post that has the solution for this.

This error is caused by an Excel add in that use an old version of post method which was there in Sharepoint Team Services 1.0. To solve this, we need to direct the excel add-in to communicate with Sharepoint using SOAP through these steps:

  1. Open up C:\Program Files\Microsoft Office\Office12\1033\EXPTOOWS.XLA
  2. Bring up the VBA window using Alt+F11
  3. Find the Initialize() method
  4. Comment out the following line:
    lVer = Application.SharePointVersion(URL)
  5. Put in the following line:
    lVer = 2
  6. Save the Excel add in and retry your import
%d bloggers like this: