1

Error while trying to import a spreadsheet into SharePoint 2013. -> site contents > add an app > import spreadsheet. Error exists on both Chrome and IE11.

enter image description here

Have tried lowered the security and activated all ActiveX components but problem still persists.

  • are you using IE 11 or edge? – Waqas Sarwar MVP Apr 7 '16 at 19:29
  • IE11 32-bit as mentioned. Operating in Windows 7. – s.inxanh Apr 8 '16 at 0:52
0

You can try to enable the SharePoint SpreadSheet Launcher in the IE.

IE-> Manage add-ons > Clcik on All Add-ons > then click to SharePoint SpreadSheet Launcher and click on Enable. Close the window then browser and try again.enter image description here

Some time you need to restart the PC.

Also try to Open the Browser in Compatibility Mode and then test it.

  • The add-on SharePoint Spreadsheet Launcher is enabled by default. – s.inxanh Apr 8 '16 at 0:56
  • Anyway, thanks for the reply! Error still persists. Compatibility Mode component is completely disabled with no options to enable. FYI, I currently do not have administrator privileges, does it matter? – s.inxanh Apr 8 '16 at 1:15
0

Dev mode (F12) > Change document mode from Edge to 10.
IE will reload and import should work.

0

Open a Preview of your site from Sharepoint designer

This way you will make sure that designer is "hooked" to the browser. Then navigate on the browser ( Make sure its IE 9 or 10) to

  1. Site content
  2. Add app
  3. Import from Excel

It should work now

  • Is the problem fixed? What version of Office are you using? We just updated to 2016 and it broke this functionality. Still waiting for Msft to address the issue. – matt Jun 5 '17 at 0:29
0

SharePoint is introducing a feature to create a list from an Excel spreadsheet that's been uploaded to a SharePoint site. Not available in the version I'm using at the moment.

A work-around is to upload the spreadsheet into MS Access (if you have it), and publish to SharePoint from there.

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.