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.

Related Links:

Best SharePoint Hosting Pricing

Apps4Rent’s SharePoint 3.0 Site Hosting

Free SharePoint Hosting Templates

Pointing your SharePoint site after signup

Adding a new SharePoint site with new domain

How many SharePoint sites can I add?

Adding/Modifying themes in SharePoint

Backup and restoring SharePoint sites using SharePoint Designer

Leave a Reply

Submit Your Requirement