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
Advertisements

Posted on November 19, 2008, in Sharepoint and tagged , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: