Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

method 'post' of object 'IOWSPostData' failed

method 'post' of object 'IOWSPostData' failed

method 'post' of object 'IOWSPostData' failed

I am receiving this error when I attempt to import a spreadsheet into Sharepoint 2007.  Please assist.



RE: method 'post' of object 'IOWSPostData' failed

I found the answer.  Here is a link: http://travislaird.com/blog/default.aspx

I have copied the explanation here:

Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. Again, not really a problem with WSS 3.0 but rather the result of a failed Application.SharePointVersion() call in the Excel Add-In which results in Excel attempting to use the IOWSPostData.Post() method to publish the Excel range which is used with SharePoint Team Services 1.0. By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with WSS 3.0 and the publish request will be successful. To make this change, open the Excel Add-In EXPTOOWS.XLA locate in C:\Program Files\Microsoft Office\Office12\1033 by default. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL). Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:

Sub Initialize(List, Title, URL, QuickLaunch)

strQuickLaunch = QuickLaunch

aTarget(iPublishURL) = URL

aTarget(iPublishListName) = List

aTarget(iPublishListDesc) = Title

'lVer = Application.SharePointVersion(URL)

lVer = 2

End Sub

RE: method 'post' of object 'IOWSPostData' failed

Finally I managed to alter the XLA-fil. I work with Vista, WSS 3.0 and Office 2007, and I think all the security-stuff on Vista created access problems to the file. The file had to be copied to my Documents-folder, do the changes, and then copied back.

Well anyway, it did not do the trick for me.
The initial error message about 'Post' of object 'IOWSPostData' dissapeared, but a new one showed up:
"Cannot connect to the server at this time. Your table cannot be published"

Ever seen this one? I get this message when I push the “Import” button in Sharepoint.

Any solutions anyone?   bigears

Vista/Office 2007/WSS 3.0


RE: method 'post' of object 'IOWSPostData' failed

I changed the code as follows and everything worked immediately for MS OSS 2007 and WSS 3.0 and MS Office 2007:

<before the change>
lVer = Application.SharePointVersion(URL)
<before the change>

<after the change>
lVer = Application.SharePointVersion(URL)
lVer = 3
<after the change>

Albert VH

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close