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.

Improve this question
2
  • are you using IE 11 or edge?
    – Waqas Sarwar MVP ♦
    Commented Apr 7, 2016 at 19:29
  • IE11 32-bit as mentioned. Operating in Windows 7.
    – s.inxanh
    Commented Apr 8, 2016 at 0:52

4 Answers 4

Reset to default
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.

Improve this answer
2
  • The add-on SharePoint Spreadsheet Launcher is enabled by default.
    – s.inxanh
    Commented Apr 8, 2016 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
    Commented Apr 8, 2016 at 1:15
0

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

Improve this answer
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

Improve this answer
1
  • 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
    Commented Jun 5, 2017 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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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