Work around for “Method ‘Post’ of object ‘IOWSPostData’ failed”

I’ve seen quite a bit of chatter around people having difficulties importing Excel spreadsheets into WSS 3.0 (or MOSS 2007 utilizing WSS 3.0 of course). Particularly, it seems more prevalent when using Excel 2007 over Excel 2003.

There are many posts about modifying Excel macro files, etc. However, I found the solution was pretty simple, at least for me.

  • Add the site you trying to import to, into your Local Intranet Sites’ list
  • Clear your IE cache (after/following any attempted imports and after adding to your Intranet sites list
  • Be sure to use a named range in Excel (my preference anyways)

Hope that helps.