You are here: Home » The fix for: Method Post Error in Excel 2007 Import Spreadsheet to SharePoint
  • March
  • 7
  • 2007

The fix for: Method Post Error in Excel 2007 Import Spreadsheet to SharePoint

Posted by unclaimed blog
No Comments »

Have you tried importing a Excel 2007 spreadsheet into SharePoint Service v3 and are getting a Method Post Error? Thanks to an open SharePoint forum, someone posted the fix. 

I take no credit for this fix. My SharePoint hosting company is www.frontpages-web-hosting.com and on their forum is a post by Bradley Elder (Thanks Bradley!) I was able to easily apply the change mentioned in his post and can now import a spreadsheet from Excel 2007 to SharePoint Services v3.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

Here is his post below:

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 FilesMicrosoft OfficeOffice121033 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

 
~~~~~~~~~~~~~~~~~~~~~~~~~ 
Andrea Kalli
Andrea Kalli Virtual Trainer and Assistant, LLC
www.virtualassist.net

Filed under: Uncategorized

Your email is never shared.
Required fields are marked *




Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


  • March
  • 7
  • 2007

The fix for: Method Post Error in Excel 2007 Import Spreadsheet to SharePoint

Posted by unclaimed blog
No Comments »

Have you tried importing a Excel 2007 spreadsheet into SharePoint Service v3 and are getting a Method Post Error? Thanks to an open SharePoint forum, someone posted the fix. 

I take no credit for this fix. My SharePoint hosting company is www.frontpages-web-hosting.com and on their forum is a post by Bradley Elder (Thanks Bradley!) I was able to easily apply the change mentioned in his post and can now import a spreadsheet from Excel 2007 to SharePoint Services v3.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

Here is his post below:

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 FilesMicrosoft OfficeOffice121033 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

 
~~~~~~~~~~~~~~~~~~~~~~~~~ 
Andrea Kalli
Andrea Kalli Virtual Trainer and Assistant, LLC
www.virtualassist.net

Filed under: Uncategorized

Your email is never shared.
Required fields are marked *




Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>