Method 'post' of object 'IOWSPostData' failed
Realistically I'm talking about two different problems in this post HOWEVER I found them directly linked in my scenario so maybe you will too.
First Error: Method 'post' of object 'IOWSPostData' failed
Cause:
This is caused by a failed application add-in contained in Excel 2007;
Resolution
You need to modify an XLA file within Excel to resolve this problem - Please also remember to always backup files before modifying them.
To make this change, open the Excel Add-In EXPTOOWS.XLA located in C:\Program Files\Microsoft Office\Office12\1033 by default. (Enable Macro's as opening)
Once opened, press ALT + F11 to open the VB editor and ADD the following line:
IVer = 2
BEFORE:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title'
lVer = Application.SharePointVersion(URL)
End Sub
AFTER:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = Quick…
First Error: Method 'post' of object 'IOWSPostData' failed
Cause:
This is caused by a failed application add-in contained in Excel 2007;
Resolution
You need to modify an XLA file within Excel to resolve this problem - Please also remember to always backup files before modifying them.
To make this change, open the Excel Add-In EXPTOOWS.XLA located in C:\Program Files\Microsoft Office\Office12\1033 by default. (Enable Macro's as opening)
Once opened, press ALT + F11 to open the VB editor and ADD the following line:
IVer = 2
BEFORE:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title'
lVer = Application.SharePointVersion(URL)
End Sub
AFTER:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = Quick…