Importing lists from Excel 2007
If Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog then do the following:
Go to C:\Program Files\Microsoft Office\Office12\1033 and locate the file "EXPTOOWS"
After locating the EXPTOOWS file double click it and it will open a new Excel 2007 window. (1) Press ALT + F11 on your keyboard (2) then in the new Excel 2007 window minimize the first screen that opens and go to the code view.
(3) As highlighted in the screenshot then use the Find function to search for
lVer = Application.SharePoint – depending on when you installed Excel 2007 and what patch
level you're on, the code that is displayed next may be different.
(4) If there is no line below "lVer = Application.SharePoint….." add a new line that reads
lVer = 2 after that
(5) save and close Excel. Retry the operation with your SharePoint site.
If it still doesn't work try replacing what you just did with lVer = 3 and saving the file
and rebooting your computer.
