I’m seeing an error when trying to import an Excel 2007 spreadsheet to a list.
"Import to Windows SharePoint Services list
Method ‘Post’ of object ‘IOWSPostData’ failed"
A quick Google search showed that (unsurprisingly) plenty of other people have experienced the same problem. Some are reporting that making a change to the code in one of the Excel Add-ins fixed the problem, but my testing showed that this just resulted in a different error.
"Cannot connect to the server at this time. Your table cannot be published"
Further testing on our environment showed that even without messing with the Excel Add-in, an import worked fine on a subsite, but not on a top level site (site collection root).
There are some custom site templates installed, so I initially suspected them, but have since proven the problem exists even with the Microsoft default templates.
Interestingly, an import works fine on a Personal Site / MySite, which itself is a top level site / site collection.
I feel a call to Microsoft coming on…
Posted by ee61re 