Import Spreadsheet Error: Method ‘Post’ of object ‘IOWSPostData’ Failed

We were trying to import Excel sheet data into SharePoint and got following error:

 Method ‘Post’ of object ‘IOWSPostData’ Failed

 Resolution:

 Need to perform following steps: 

  • Go to “C:\Program Files\Microsoft Office\Office12\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.
Advertisements

9 Comments »

  1. Darren said

    I changed EXPTOOWS.XLA per the above instructions. Now when I try to create a SharePoint list by importing an Excel spreadsheet, I receive the following error message: “Cannot connect to server. Your table cannot be published.” Has anyone else received this message and, if so, how did you resolve the problem?

  2. courtney said

    Here’s the solution. You have to put a single quote before “lVer = Application.SharePointVersion(URL)” to comment it out. Then do lVer = 2

    It’s in the blog below.

    http://johnqbrunsonjr.blogspot.com/2007/03/method-post-of-object-iowspostdata.html

  3. Phil said

    I get same error as Darren.

  4. IRAD said

    Phil, Darren, you need to add the sharepoint top site to the list of approved sites in your internet browser. Go to options->security, etc.

  5. Tim said

    This worked pefectly! Sharepoint 2007–> Excel 2010! THANKS

  6. fahmi paridin said

    Just drop by to say “thanks” 😉

    • Farhan Faiz said

      Fahmi, thanks a lot for dropping by.

      Hope you visit again 🙂

  7. Anonymous said

    it works…thank you so much 😀

  8. Anonymous said

    it works (y)

RSS feed for comments on this post · TrackBack URI

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: