Method Post of object IOWSPostData failed

Method ‘Post’ of object ‘IOWSPostData’ failed
You may get this error while importing Excel sheet in a Microsoft Office Sharepoint Server 2007 list. Under the hood code inside Addin EXPTOOWS.XLA is being called.

Resolution:

  • Open Microsoft Office 2007 Excel
  • Click Excel Option in Main Menu
  • Click Add-Ins in Left Area
  • In Manage Drop down, Select Excel-Addins and press Go
  • Browse for EXPTOOWS.XLA in directory c:\Program Files\Microsoft Office\Office12\1033 and Click Ok
  • Press Alt + F11
  • Search for “lVer = Application.SharePointVersion(URL)”, without qoutes, comment it by putting single qoute (‘)
  • Put a new line of code as “lVer = 2” without qoutes. And Reset MOSS 2007 machine to take affect the changes.
  • Execute the following commands:
  • stsadm -o backup -url http://PORTAL-URL -filename “c:\Backups\BACKUP-FILE.dat”
    stsadm -o restore -url http://PORTAL-URL -filename “c:\Backups\BACKUP-FILE.dat” -overwrite

    stsadm Command Reference

    Cheers đŸ™‚

    Advertisements

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out /  Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s

    %d bloggers like this: