I'm doing research as to why the Import Spreadsheet app in SharePoint 2013 (on prem) no longer works as I have Office 2016 installed on my Windows 7 computer using IE11.

enter image description here

the following message appears when I attempt to do so.

enter image description here

The only workaround I found so far is to approach this from excel 2016 and create a table and use the Export table to SharePoint list wizard found under the Design tab instead of importing it from the Import Spreadsheet app on SharePoint.

enter image description here

Any thoughts on how I might further troubleshoot this app would be most helpful.


Hope that below Cumulative Update from Microsoft should resolve the issue related to importing from Excel 2016.


  • 1
    Instead of directly pasting links you can quote important points and then add reference, – John Zachariah Aug 1 '17 at 2:29

After doing more testing I found that this worked on another workstation and narrowed it down to my computer that had the issue.

long story short I ran gpupdate /force in command prompt or powershell to update my computers policy / security information. This resolved the issue for me.

  • Recent update to Office 2016 broke the import function completely for me. On a machine with Office 2013 I see the same error as you but updating policies had no effect. – matt Jun 5 '17 at 1:44
  • Did you try it in different browsers? (Edge / IE11 / other?) – Chris G Jun 5 '17 at 15:41
  • IE10 and IE11 and compatibility view (IE9). Also using the dev tools emulation thingy. – matt Jun 5 '17 at 23:30
  • This didn't solve my issue, but I did find a workaround here: sharepoint.stackexchange.com/questions/211917/… – TylerH Mar 28 '18 at 15:19

This is because of permissions. The user who is trying to open the (.iqy) file should be also added in site or site collection. Try after adding the user. I faced the same issue and it helped :).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.