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
"The above solution provided by Bradley Elder" Thanks man you rock!!
Subscribe to:
Post Comments (Atom)
11 comments:
Hi John,
i'm working for an important Italian Software House and we managed this problem from some our customers. Do you know if is there any Patch to fix this problem? because i think it's unacceptable to make this to each single user's PC.
Thanks a lot,
Sebastian Macheda
Very helpful. This little tip saved me hours if not days!!!
Thanks
I tried the fix you have listed (thank you by the way) but I am now prompted with the "Cannot connect to the server at this time. You table cannot be published." error message.
Any ideas? I've seen other people on the net with this same issue. Ideas?
I got exactly the same error as Ryan.
Thank you very much. It works for me too.
Thank you, thank you, thank you! You just resolved two days of frustrating error messages that meant nothing. One quick fix and I'm on the road to awesome SharePoint application creation! You rock!
Nice solution. Thanks a lot!
Jim
I to get exactly the same error as Ryan.
Update: I only get this error on sub-sites (not top level sites). The only thing that works for me is to import to the top level site, save as list template, then recreate in sub-site.
Post a Comment