Solved

Method 'Post' of object 'IOWSPostData' Failed error message when importing excel into SP

Posted on 2011-02-16
3
851 Views
Last Modified: 2012-05-11
TRYING TO: Create sharepoint list using 'Import Spreadsheet' option.
USING: Sharepoint 2010 and Excel 2010
Error:  method 'Post' of object 'IOWSPostData' failed
Troubleshooted using : http://makingspwork.blogspot.com/ 

MY PROBLEM: I renamed EXPTOOWS.XLA to oldEXPTOOWS.XLA and recreated new one with the lVer = 2 but when I try to import spreadsheet after restarting computer and browser Microsoft Office recreates EXPTOOWS.XLA with the original files time and date stamp wherein the changes I've made in the new version are not picked up.

Any help will be appreciated.

Gayathri
0
Comment
Question by:enervest
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Expert Comment

by:irinuc
ID: 34917363
Hi,

Does it work if you do not restart your computer? Restart only the browser and Office.

I wonder if the change is taken into consideration at all.
0
 

Accepted Solution

by:
enervest earned 0 total points
ID: 34917422
I got it to work now...

As per the instructions on the above mentioned blogspot, change the file type to Excel Add-in (.xla). didnt work, it saved it as .xlam, however if saved as Excel 97-2003 add in then it saved as .xla
0
 

Author Closing Comment

by:enervest
ID: 34949702
This solved it for me.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question