When I try to import a spreassheet and clicked import after typed the Title, It says

Your browser should support ActiveX for the import operation.

I couldn't understand what here written. http://social.technet.microsoft.com/wiki/contents/articles/15995.import-excel-sheet-as-sharepoint-list.aspx

What should I do for it? Thank you.


Well have you tried to enable ActiveX in your browser?

If you use IE: http://windows.microsoft.com/en-us/windows/help/genuine/ie-activex

  • The options are like what written in page. When I click import now, it says "Could not load an object because it is not available on this machine" – e.ozmen Aug 21 '13 at 8:01
  • Is the site in your local intranet or in the trusted sites? – hupseb Aug 21 '13 at 8:02
  • Local intranet. – e.ozmen Aug 21 '13 at 8:03
  • When I click ok for that message, it opens excel in Microsoft Visual Basic for Applications and a message prompt. I says"Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and tgen mark them with PtrSafe attribute."Here is a screenshot compfreek.files.wordpress.com/2013/08/capture1.png – e.ozmen Aug 21 '13 at 8:09
  • Hmm... are you opening it with a 64bit version IE? Maybe try the 32bit version. – hupseb Aug 21 '13 at 8:12

The linked article in your link was listed as not found - so I am outlining the two ways that I am aware of to import spreadsheet data to Sharepoint without code.

The first is to use the out-of-the-box import spreadsheet app part. If you encounter errors during this approach, we will need more information to determine what the problem may be. I do not anticipate an ActiveX error based on this approach, and without being able to review the linked article, it will be hard to tell what the issue may be if you did encounter an ActiveX error while doing so.

The second option is to utilize the super unstable ActiveX plugins that Sharepoint 2013 offers. You need to use Internet Explorer 32 bit for this option. What you do is you essentially a copy and paste (Ctrl+C in MS Excel, then go to sharepoint via IE and select the first cell on a new line while on the "Quick Edit" view on the list, the do a Ctrl+V). It is not recommended to do more than 50 rows of edit at at time using this approach, as it may crash the script.

Hope this is helpful!

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.