When importing an Excel spreadsheet right into a SharePoint Record I bumped into this error on a pc operating Home windows XP SP2 and Workplace 2003. Then I attempted importing on a Home windows Vista pc operating Workplace 2007. After doing a little analysis I discovered an answer on Microsoft MVP Kathy Hughes’ weblog.
I’m documenting the answer for Workplace 2007 right here however the answer for Workplace 2003 needs to be related. Simply substitute the references accordingly. For instance, in step 2 you’ll substitute the reference to Workplace 12 with Workplace 11.
Error
I skilled the error after I tried to import the spreadsheet. The error states:
Methodology ‘Publish’ of object ‘IOWSPostData’ failed
Trigger
This error is outwardly attributable to a failed Utility.SharePointVersion(URL) name within the Excel add-in which causes Excel to attempt to use the IOWSPostData.Publish() to publish the vary. This technique is utilized by SharePoint Group Companies 1.0. In case you can power it to make use of model lookup end result variable (lVER) to a later model (e.g. 2 or later), Excel will use SOAP to speak with WSS 3.0 and you need to be capable of import the info efficiently.
Resolution
1. Open Excel 2007.
2. Open EXPTOOWS.XLA add-in which is situated by default in C:Program FilesMicrosoft OfficeOffice121033 folder. If prompted, Allow the macros.
3. Press ALT+F11. You need to see the Microsoft Visible Fundamental code editor window as proven beneath.
If you don’t see the code editor window open. Go to ExptoOWS (EXPTOOWS.XLA, Kinds folder and double-click publishForm. Press F7 (or View, Code from menu) to open the code editor.
4. It’s worthwhile to find the lVer = Utility.SharePointVersion(URL) code. Use CTRL+F to find the code, as proven above. The letter earlier than “Ver” is a lowercase L, not the #1.
5. Remark out the road that claims lVer = Utility.SharePointVersion(URL) as follows:
‘lVer = Utility.SharePointVersion(URL)
6. Add a line lVer =2. Your two strains ought to now learn:
‘lVer = Utility.SharePointVersion(URL)
lVer = 2
Discover the apostrophe ‘ earlier than line one.
7. Save the file and exit Excel.
8. You need to now be capable of import Excel information into SharePoint Lists with none issues.
