Error: “Method ‘Post’ of object ‘IOWSPostData’ failed” in SharePoint

You may also like...

15 Responses

  1. Somoose says:

    Thanks for posting this solution. I’ve been fighting this exact problem for several days, and you just solved it for me!

  2. Dasen says:

    How can the solution be to open Excel 2007 when I’m using Excel 2003. I’m trying to import a file into SharePoint 2007 and when i press the import button, it just sits there, but then i close the process and it says Import Aborted. I don’t have Office 2007 available. I’m confused by your answer. Do i need to have Excel 2007 in order to do this import? And if i don’t, i’m out of luck?

    Thank you in advance for your help!
    Dasen

  3. Zubair Alexander says:

    Dasen, You don’t need Excel 2007 for importing. My solution was written for Excel 2007 but you can use Excel 2003. Just follow the same steps as for Excel 2007 but replace the references to Excel 2003 accordingly.

  4. Cristi says:

    I’m using Excel 2003 and have followed these steps exactly as described. However, I’m not finding the “lVer = Application.SharePointVersion(URL)” code that I’m searching for. Any ideas?

  5. Zubair Alexander says:

    Cristi,

    First of all make sure that you are editing the EXPTOOWS.XLA file in Office11 folder and not Office12, in case you have both versions installed. Because the line “lVer = …..” is commented out anyway, just add the “lVer = 2” (without the quotes) at that location.

  6. Reg says:

    Hi, I am using Excel 2003. The Office12 directory does not exist on my machine. I can find this file in the Office11 directory, but it looks like the IVer = Application.SharePointVersion(URL) does not exist. I don’t know what to do. Any help is welcome.

  7. Zubair Alexander says:

    Reg,

    I’ve already mentioned in my article (step 2) that for Office 2003 you need to use Office11 folder. The “lVer = …..” is commented out anyway so you just need to add the “lVer = 2″ (without the quotes) line at that location in the file.

  8. Shawn says:

    Dansen / Cristi, I’ve found the solution for Excel 2003. Instead of trying to perform the standard “create List / Import Excel” thing and getting the error that we ALL get with 2003, try this: From Excel, select the data you want to use in the Custom List, go: Data | List | Create List. This will create the list. THEN (still in excel) go back to Data | List | Publish List. This brings up a dialogue box asking for the URL of the SharePoint site. What I did was copy and paste the URL without the .aspx file (http://mysharepointsite.com/marketing/ ’cause I wanted to put the custom list in the Marketing SubSite). Give it a name and click Next. It will show you how the fields will be created (text, numbers, dates whatever..) then click Finish.

    Good Luck.

  9. Gold says:

    A wonderful article…. this is just what I needed to read today. Thanks for describing the way you work and how you structure your writing projects. I’ll go read that article now.

  10. Aidan says:

    Hi Alexander,

    I followed your steps and changed the code in EXPTOOWS.XLA. However, after saving and trying to import again, I get a new 1004 error “application or object defined” and then the debugger stops at the following line in EXPTOOWS.XLA “rng.QueryTable.Delete ‘ delete query table if there is one on the range”

    Any thoughts on this – many thanks.

  11. Nathan A says:

    Bloody amazing mate! Thank you. Your fix worked like a charm. You rock.

  12. TPhillips says:

    What do I do if the lVER does not even come up in the search? I’m in VB and that string does not even come up. Now what? I still get the error.

  13. Mathi says:

    Thanks lot. I was using Excel 2003 and was searching for days how to get the spreadsheet into my SharePoint site and now I got it working. Thank you so much for sharing this information.

  14. Zubair Alexander says:

    Mathi,
    I am glad you found this post useful. Microsoft Excel’s integration with SharePoint is appreciated by most people. After all, Excel is the most popular database on the planet.
    Zubair

  15. Koen says:

    Hi, thanks for this post, helped me a lot! Little side note, works also perfectly with Office2010 and WSS3.0 SP2…

    Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

three × 5 =