We are using SharePoint 2013 on-premise standard edition. Our users desktop have Office 2010 installed.
Recently user test the import Excel spreadsheet into SharePoint 2013 list function. He tested with a very simple Excel sheet. However when he selected some cells and click "Import" button, error "Method Post of object IOWSPostData failed" is prompted.
I found the same error on Internet but all of them are about older version SharePoint.
We tested create a subsite and then import the same Excel again. No error is occur.
Why is that?