method 'post' of object 'IOWSPostData' failed
method 'post' of object 'IOWSPostData' failed
(OP)
I am receiving this error when I attempt to import a spreadsheet into Sharepoint 2007. Please assist.
Thanks,
Andrew
Thanks,
Andrew
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
method 'post' of object 'IOWSPostData' failed
|
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.
RE: method 'post' of object 'IOWSPostData' failed
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
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?
Vista/Office 2007/WSS 3.0
HeidiSitara
RE: method 'post' of object 'IOWSPostData' failed
<before the change>
lVer = Application.SharePointVersion(URL)
<before the change>
<after the change>
lVer = Application.SharePointVersion(URL)
lVer = 3
<after the change>
Albert VH