• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1050
  • Last Modified:

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

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
enervest
Asked:
enervest
  • 2
1 Solution
 
irinucCommented:
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
 
enervestAuthor Commented:
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
 
enervestAuthor Commented:
This solved it for me.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now