Error while importing SpreadSheet into a SharePoint site
Error while Importing Excel Spreadsheet into a SharePoint site:
These steps are valid for error method ‘post’ of object ‘IOWSPostData’ failed. To fix this error; please read the following document.
This error is not due to Windows SharePoint Services 3.0; but result of a failed Application.SharePointVersion() call in the Excel Add-In. This 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,
1. Open the Excel Add-In EXPTOOWS.XLA locate in C:\Program Files\Microsoft Office\Office12\1033 by default.
2. Press Alt+F11 to display the Visual Basic code editor.
3. Search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).
4. 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
5. Save the changes.
6. Try again.
With the best SharePoint hosting price plans in the industry, Apps4Rent provides any sized business the power to integrate the virtual collaboration technology into their business model and streamline communications at a minimal SharePoint hosting price rate of $8.95 per month.
