{"id":678,"date":"2009-08-22T06:16:24","date_gmt":"2009-08-22T10:16:24","guid":{"rendered":"https:\/\/apps4rent.com\/support\/?p=678"},"modified":"2024-09-30T17:03:37","modified_gmt":"2024-09-30T17:03:37","slug":"error-while-importing-spreadsheet-into-a-sharepoint-site","status":"publish","type":"post","link":"https:\/\/www.apps4rent.com\/support\/kb\/article\/error-while-importing-spreadsheet-into-a-sharepoint-site","title":{"rendered":"Error while importing SpreadSheet into a SharePoint site"},"content":{"rendered":"

Error while Importing Excel Spreadsheet into a SharePoint site:<\/strong><\/span><\/p>\n

These steps are valid for error method ‘post’ of object ‘IOWSPostData’ failed.<\/strong> To fix this error; please read the following document.<\/p>\n

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.<\/p>\n

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,<\/p>\n

1. Open the Excel Add-In EXPTOOWS.XLA locate in C:\\Program Files\\Microsoft Office\\Office12\\1033 by default.<\/p>\n

2. Press Alt+F11 to display the Visual Basic code editor.<\/p>\n

3. Search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).<\/p>\n

4. Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:<\/p>\n

Sub Initialize(List, Title, URL, QuickLaunch)<\/p>\n

strQuickLaunch = QuickLaunch<\/p>\n

aTarget(iPublishURL) = URL<\/p>\n

aTarget(iPublishListName) = List<\/p>\n

aTarget(iPublishListDesc) = Title<\/p>\n

‘lVer = Application.SharePointVersion(URL)<\/p>\n

lVer = 2<\/p>\n

End Sub<\/p>\n

5. Save the changes.<\/p>\n

6. Try again.<\/p>\n

With the best SharePoint<\/span> <\/a>hosting price plans<\/strong> 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.<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,1068],"tags":[878,877,876],"class_list":["post-678","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-troubleshoot-error-messages-sharepoint","tag-importing-spreadsheet-sharepoint","tag-sharepoint-error-spreadsheet","tag-sharpoint-error"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts\/678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/comments?post=678"}],"version-history":[{"count":1,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts\/678\/revisions"}],"predecessor-version":[{"id":24465,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/posts\/678\/revisions\/24465"}],"wp:attachment":[{"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/media?parent=678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/categories?post=678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apps4rent.com\/support\/wp-json\/wp\/v2\/tags?post=678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}