We were trying to import Excel sheet data into SharePoint and got following error:
Method ‘Post’ of object ‘IOWSPostData’ Failed
Resolution:
Need to perform following steps:
- Go to “C:\Program Files\Microsoft Office\Office12\1033”.
- Find “EXPTOOWS.XLA” and double click on it.
- Press “Alt+F11” to display VB code editor.
- Select code window and find “lVer = Application.SharePointVersion(URL)”
- Add following line “lVer = 2”.
- Save and close the window.
- Restart and see if it worked.
- If not, change “lVer = 3”.
- Restart and see if it worked.
Darren said
I changed EXPTOOWS.XLA per the above instructions. Now when I try to create a SharePoint list by importing an Excel spreadsheet, I receive the following error message: “Cannot connect to server. Your table cannot be published.” Has anyone else received this message and, if so, how did you resolve the problem?
courtney said
Here’s the solution. You have to put a single quote before “lVer = Application.SharePointVersion(URL)” to comment it out. Then do lVer = 2
It’s in the blog below.
http://johnqbrunsonjr.blogspot.com/2007/03/method-post-of-object-iowspostdata.html
Phil said
I get same error as Darren.
IRAD said
Phil, Darren, you need to add the sharepoint top site to the list of approved sites in your internet browser. Go to options->security, etc.